B
AREA
South
South
South
North
East
North
=COUNTIF(B4:B9,"south")*1 - this formula evaluates correctly as '3'
I also see that the following formula evaluates to '3'"
=SUMPRODUCT(--(B4:B9="South"))
I thought that SUMPRODUCT works on an 'array' of cells such that you can take a qty from once cell and multiply it by a price in another, and have this done for a whole group of cells using SUMPRODUCT, but in the second formula above, SUMPRODUCT seems to work just like a 'COUNTIF', though it is not taking one value and multiplying it by another.
Would very much appreciate if someone could help me better understand this formula!
Thanks!
AREA
South
South
South
North
East
North
=COUNTIF(B4:B9,"south")*1 - this formula evaluates correctly as '3'
I also see that the following formula evaluates to '3'"
=SUMPRODUCT(--(B4:B9="South"))
I thought that SUMPRODUCT works on an 'array' of cells such that you can take a qty from once cell and multiply it by a price in another, and have this done for a whole group of cells using SUMPRODUCT, but in the second formula above, SUMPRODUCT seems to work just like a 'COUNTIF', though it is not taking one value and multiplying it by another.
Would very much appreciate if someone could help me better understand this formula!
Thanks!