SUMIF - Can I total the value of cells if three other cells = set

[mg_sv_r]

Hi,

Once again I need your help.

Suppose I have a spreadsheet that looks pretty much like this but much
larger!!!...

A B C D
1 mon ax dec 0.23
2 Tue ax dec 1.75
3 mon ax acc 0.78

I need a formula that will, for example, give me the total of the values in
column D for all rows where Column A = Mon, B = AX and C = dec

Any ideas????

Your help would be much appreciated.

Regards
John

[Peo Sjoblom]

=SUMPRODUCT(--(A1:A500="Mon"),--(B1:B500="AX"),--(C1:C500="Dec"),D1:D500)


--

Regards,

Peo Sjoblom

"mg_sv_r" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> Once again I need your help.
>
> Suppose I have a spreadsheet that looks pretty much like this but much
> larger!!!...
>
> A B C D
> 1 mon ax dec 0.23
> 2 Tue ax dec 1.75
> 3 mon ax acc 0.78
>
> I need a formula that will, for example, give me the total of the values
in
> column D for all rows where Column A = Mon, B = AX and C = dec
>
> Any ideas????
>
> Your help would be much appreciated.
>
> Regards
> John

[mg_sv_r]

Thank you so much, spent ages trying to work that one out, think Ive fried my
brain.

ANyway, your help is much appreciated, you're a genuis!!!

"Peo Sjoblom" wrote:

> =SUMPRODUCT(--(A1:A500="Mon"),--(B1:B500="AX"),--(C1:C500="Dec"),D1:D500)
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "mg_sv_r" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > Once again I need your help.
> >
> > Suppose I have a spreadsheet that looks pretty much like this but much
> > larger!!!...
> >
> > A B C D
> > 1 mon ax dec 0.23
> > 2 Tue ax dec 1.75
> > 3 mon ax acc 0.78
> >
> > I need a formula that will, for example, give me the total of the values
> in
> > column D for all rows where Column A = Mon, B = AX and C = dec
> >
> > Any ideas????
> >
> > Your help would be much appreciated.
> >
> > Regards
> > John
>
>
>

[Bob Phillips]

=SUMPRODUCT(--(A1:A20="mon"),--(B1:B20="ax"),--(C1:C20="dec"),D1:D20)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mg_sv_r" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> Once again I need your help.
>
> Suppose I have a spreadsheet that looks pretty much like this but much
> larger!!!...
>
> A B C D
> 1 mon ax dec 0.23
> 2 Tue ax dec 1.75
> 3 mon ax acc 0.78
>
> I need a formula that will, for example, give me the total of the values
in
> column D for all rows where Column A = Mon, B = AX and C = dec
>
> Any ideas????
>
> Your help would be much appreciated.
>
> Regards
> John