array formula for conditional sum

[jrg24]

Hi all. I cannot post any data here at the moment, so I am providing this link to help demonstrate what I want to do.
http://www.mrexcel.com/tip083.shtml
First off I am using excel 2010 and as far as I can tell the conditional sum wizard is not in this version of excel. What I am trying to do is essentially what is shown in this link with the exception that in column A of my sheet, where they have a product category, I have eight digit numbers that I need to use as a condition based on their range(greater than or equal to 5, less than equal to 15, for example) AND the sales rep name. Anyone have an idea how I can accomplish this? I have tried several different things in vain and could really use some help.
I hope this makes sense. Thanks in advance for your help

 

[Aladin Akyurek]

Hi all. I cannot post any data here at the moment, so I am providing this link to help demonstrate what I want to do.
http://www.mrexcel.com/tip083.shtml
First off I am using excel 2010 and as far as I can tell the conditional sum wizard is not in this version of excel. What I am trying to do is essentially what is shown in this link with the exception that in column A of my sheet, where they have a product category, I have eight digit numbers that I need to use as a condition based on their range(greater than or equal to 5, less than equal to 15, for example) AND the sales rep name. Anyone have an idea how I can accomplish this? I have tried several different things in vain and could really use some help.
I hope this makes sense. Thanks in advance for your help

Try...

E2: 5
F2: 15
G2: Joe

On Excel 2007 or later: In H2 just enter and copy down...

=SUMIFS($C$2:$C$30,$A$2:$A$30,">="&E2,$A$2:$A$30,"<="&F2,$B$2:$B$30,G2)


On all versions...

Either just enter:

=SUMPRODUCT(
$C$2:$C$30,
--($A$2:$A$30>=E2),
--($A$2:$A$30<=F2),
--($B$2:$B$30=G2))

Or, control+shift+enter, not just enter:

=SUM(
IF($A$2:$A$30>=E2,
IF($A$2:$A$30<=F2,
IF($B$2:$B$30=G2,
$C$2:$C$30))))