| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
I want to single out a sum that has two common detonators row A and B, IF row
A=1 and row B=2 then sum row C |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
Try this, adjust the range to match your data:
=SUMPRODUCT(--(A1:A100=1), --(B1:B100=2), C1:C100) Does that help? -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Peter" wrote: I want to single out a sum that has two common detonators row A and B, IF row A=1 and row B=2 then sum row C |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
That's quite an explosive worksheet you have<g
Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 12:31:02 -0800, Peter wrote: I want to single out a sum that has two common detonators row A and B, IF row A=1 and row B=2 then sum row C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct assistance pleas | Excel Discussion (Misc queries) | |||
| PLEAS HELP! Newby Needs help Populating Cell w/ Application.usern | Excel Discussion (Misc queries) | |||
| Pleas help! | Excel Discussion (Misc queries) | |||
| Erro in Formula, Pleas Help? | Excel Worksheet Functions | |||
| pleas help: sumproduct function returns #value or #ref error | Excel Worksheet Functions | |||
Linear Mode
