additional conditions to SUMPRODUCT formula
Hi Fiona,
I'm not sure why you would want to count column A when whatt you are
counting is in column B. If you are counting the x's in column B and
whatever the contents are in C1, the following formula should work:
=SUMPRODUCT((B1:B10="x")+(B1:B10=C1))
HTH,
John
"Fiona Yorke-Saville" wrote:
Hi
I wondered if anyone knew if I can add another condition to this formula.
=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10&""))
I want to use the above formula if coloumn b contains c1
e.g
Coloumn A Coloumn B
1111 X
1111 X
1234 Y
1258 Z
1254 Y
I want to count Coloumn A (as detailed in the above formula) if Coloumn B
contains X (or cell C1)
Is that too many formulas?
Thanks
|