Column A has blank cells, alpha words, and numerics
Column B has blank cells and numerics in each cell
I want to count the number of cells in Column B which has 390 entered into it as long as column A has a numeric in the cell.
ie if there is alpha text or a blank cell in column A, then I do not want the equivalent cell (same position in the array) of Column B to be counted
The following is near but not close enough
=SUMPRODUCT((B2:B47>=1)*(C2:C47>=0)) gives the answer of 46, which includes blank cells and alpha cells
Thankyou in advance for any assistance given.
Last edited by Karen Day; 07-03-08 at 04:07.
Reason: not clearly showing on forum