SUMIF function

[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?

[Dav]

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

Regards

Dav

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[Jo Davis]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
>
>
>

Thanks for the feedback - glad you're sorted!

Andy.

"Jo Davis" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>> >
>>
>>
>>