Rudi Holans
Posted by Brian on February 10, 2002 8:12 AM
=SUM(IF($G$1:$G$99="employee name",IF($I$1:$I$99="vac",($H$1:$H$99))))+SUM(IF($B$1:$B$99="employee name",IF($D$1:$D$99="vac",($C$1:$C$99))))
Posted by Aladin Akyurek on February 10, 2002 10:22 AM
SUMPRODUCT, SUM(IF
Aloha Brian,
I believe you mean by employee name a name of interest like Brian or John, while "vac" is a value that qualifies numbers in $C$1:$C$99 and $H$1:$H$99. Moreover, your formula must be array-entered.
It's indeed an example of multiconditional summing applied to two different areas with the same layout. Moreover, it's equivalent to:
=SUMPRODUCT(($B$1:$B$99="brian")*($D$1:$D$99="vac"),$C$1:$C$99)+SUMPRODUCT(($G$1:$G$99 ="brian")*($I$1:$I$99 ="vac"),$H$1:$H$99)
PS. It appears that I failed to reply to you about that SUMIF glitch. Mea Culpa. I hope to come back to you on that.
Aladin
Posted by Brian on February 10, 2002 11:45 AM
Aladin
Aladin,
Much mahalo. I'll use yours, it's much shorter.
And here I was so excited to have figured something out. Thanks again for all your help and time you spend on it!
Brian
