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!