counting data in one column and match with data in another column

J

Jenny

Cant do me home work!!! I need to count deciduous tree sales (column2) in the
North East (colum2) I've tried every count function going but am really stuck
J
 
T

Trevor Shuttleworth

J

have a look at SUMPRODUCT

Something like:

=SUMPRODUCT((A1:A15="deciduous")*(B1:B15="NE")*(C1:C15))

or

=SUMPRODUCT(--(A1:A15="deciduous"),--(B1:B15="NE"),(C1:C15))

Checks column A (1) for "deciduous", column B (2) for "NE" and sums column C
(3) where both conditions are true.

Regards

Trevor
 
Top