| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| total a range of cells in Excel into a different worksheet | Excel Worksheet Functions | |||
| function to find which cells add up to a given total? | Excel Worksheet Functions | |||
| I want to only at cells that are in bold to a total in Excel | Excel Discussion (Misc queries) | |||
| how do i use the sumif function in non cons cells | Excel Worksheet Functions | |||
Linear Mode
