SUMIF function
 

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?

SUMIF function
 

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?

SUMIF function
 

Something like
=SUMPRODuct((B4:B47="4 wheelers")*(A4:A47="Bardon"),F4:F47)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=545407

SUMIF function
 

Thanks that works a treat!!

"Andy" wrote:

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?

SUMIF function
 

Thanks for the feedback - glad you're sorted!

Andy.

"Jo Davis" wrote in message
...
Thanks that works a treat!!

"Andy" wrote:

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?