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.

"Jo Davis" wrote in message
...
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?