arrays - counta formula???
Posted by MC on June 18, 2001 3:52 PM
Hi there,
I'm trying to enter an array that counts the number of cells in a particular column (found on a different worksheet) based on the following criteria:
The values in Column B on the other sheet (contains dates) falls within a certain range and the values in Column G on that other sheet are equal to e.g., "A".
I ended up setting up a separate worksheet to do the calculations, where A1 = 4-jun-01, A2 = 8-jun-01 and A3 = "A".
My formula was therefore:
{=counta(IF('June 01'!B1:B500>=A1,IF('June 01'!B1:B500<=A2,IF('June 01'!G1:G500=A3,'June 01'!B1:B500))))}
Please help!