SUMIF function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo Davis - 25 May 2006 09:15 GMT

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?

Reply to this Message

Andy - 25 May 2006 09:22 GMT

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.

> Here is my problem
>
[quoted text clipped - 16 lines]
>
> can I use the AND function?

Reply to this Message

Jo Davis - 25 May 2006 09:31 GMT

Thanks that works a treat!!

> Hi
> Try something like this:
[quoted text clipped - 25 lines]
> >
> > can I use the AND function?

Reply to this Message

Andy - 25 May 2006 09:39 GMT

Thanks for the feedback - glad you're sorted!

Andy.

> Thanks that works a treat!!
>
[quoted text clipped - 29 lines]
>> >
>> > can I use the AND function?

Reply to this Message

Dav - 25 May 2006 09:24 GMT

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

Regards

Dav

Signature

Dav

Reply to this Message