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

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

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

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


--

Regards,

Peo Sjoblom

"mg_sv_r" wrote in message
...
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

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

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

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

=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" wrote in message
...
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