SUMIF function

J

Jo Davis

Here is my problem

I want to sum the values in a column if they meet two criteria, see below:

A B C D

Site Vehicle Value 4 Wheeler Bardon

Bardon 4 Wheeler 1000
Croft 4 Wheeler 2000

Bardon 4 wheeler 3000



In column D I want it to sum the value column if A equals Bardon and B
equals 4 wheeler. I have done this with one column using the following:


=SUMIF(T4:T47,"4 wheelers",F4:F47)

can I use the AND function?
 
G

Guest

Hi
Try something like this:
=SUMPRODUCT(--(A2:A100="Bardon"),--(B2:B100="4 Wheeler"),(C2:C100))
This function cannot use full columns as ranges and the ranges must all be
the same size.

Hope this helps.
Andy.
 
J

Jo Davis

Thanks that works a treat!!

Andy said:
Hi
Try something like this:
=SUMPRODUCT(--(A2:A100="Bardon"),--(B2:B100="4 Wheeler"),(C2:C100))
This function cannot use full columns as ranges and the ranges must all be
the same size.

Hope this helps.
Andy.
Click to expand...
 
Top