Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional sumif
I've seen similar threads here but can't seem to get them to work...here is
my situation. spreadsheet 1 col A col B col C FDP cpu 1 INS tape 2 FSI disk 3 FSI cpu 4 FSI disk 5 I need the answer to this question--If Col A = FSI AND Col B = disk, sum column C. In this case, I expect 8 to be returned. I will be posting the formula in spreadsheet 2, if that is important. Please help!! -- Thanks so much! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional sumif
=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 ))
Regards Trevor "steph" wrote in message ... I've seen similar threads here but can't seem to get them to work...here is my situation. spreadsheet 1 col A col B col C FDP cpu 1 INS tape 2 FSI disk 3 FSI cpu 4 FSI disk 5 I need the answer to this question--If Col A = FSI AND Col B = disk, sum column C. In this case, I expect 8 to be returned. I will be posting the formula in spreadsheet 2, if that is important. Please help!! -- Thanks so much! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional sumif
BINGO!!!! I would never have thought to use SUMPRODUCT because I don't see
this task as a multiplication task. But heck...it works. Thank you for the quick reply and the easy solution. -- Thanks so much! "Trevor Shuttleworth" wrote: =SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 )) Regards Trevor "steph" wrote in message ... I've seen similar threads here but can't seem to get them to work...here is my situation. spreadsheet 1 col A col B col C FDP cpu 1 INS tape 2 FSI disk 3 FSI cpu 4 FSI disk 5 I need the answer to this question--If Col A = FSI AND Col B = disk, sum column C. In this case, I expect 8 to be returned. I will be posting the formula in spreadsheet 2, if that is important. Please help!! -- Thanks so much! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional sumif
You're welcome ... glad to help
"steph" wrote in message ... BINGO!!!! I would never have thought to use SUMPRODUCT because I don't see this task as a multiplication task. But heck...it works. Thank you for the quick reply and the easy solution. -- Thanks so much! "Trevor Shuttleworth" wrote: =SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 )) Regards Trevor "steph" wrote in message ... I've seen similar threads here but can't seem to get them to work...here is my situation. spreadsheet 1 col A col B col C FDP cpu 1 INS tape 2 FSI disk 3 FSI cpu 4 FSI disk 5 I need the answer to this question--If Col A = FSI AND Col B = disk, sum column C. In this case, I expect 8 to be returned. I will be posting the formula in spreadsheet 2, if that is important. Please help!! -- Thanks so much! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional sumif
I have never used this with the * sign howeverif you find that
"=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C1 0))" does not work you can try another combination of the sae i.e. =SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),--(C1:C10)) this works fine, you can also substitute the "--" with 'SumProduct' each time have fun! "Trevor Shuttleworth" wrote: =SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 )) Regards Trevor "steph" wrote in message ... I've seen similar threads here but can't seem to get them to work...here is my situation. spreadsheet 1 col A col B col C FDP cpu 1 INS tape 2 FSI disk 3 FSI cpu 4 FSI disk 5 I need the answer to this question--If Col A = FSI AND Col B = disk, sum column C. In this case, I expect 8 to be returned. I will be posting the formula in spreadsheet 2, if that is important. Please help!! -- Thanks so much! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional sumif
"Peter" wrote in message ... I have never used this with the * sign howeverif you find that "=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C1 0))" does not work you can try another combination of the sae i.e. =SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),--(C1:C10)) The * operator and the -- double unary behave in the same way (see http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation), but in both cases the operator is not needed before the straight array, only before the conditional tests =SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),C1:C10) this works fine, you can also substitute the "--" with 'SumProduct' each time This sounds very wrong to me, do you mean =SUMPRODUCT(--(A1:A10="FSI"))+SUMPRODUCT(--(B1:B10="disk"))+SUMPRODUCT(--(C1 :C10)) because that is just meaningless to me, it gives a result, but nothing near the correct result. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional sumif? | Excel Discussion (Misc queries) | |||
Conditional formatting w/ a sumif | Excel Discussion (Misc queries) | |||
Conditional sumif | Excel Discussion (Misc queries) | |||
Conditional SUMIF??? | Excel Worksheet Functions | |||
Conditional SUMIF | Excel Worksheet Functions |