Conditional formulas

[Dale]

I'm currently summing a column of numbers using the
following formula:
=sumif(BA23:BA500,"y",N23:N500)

I would now like to break down the sum based on a second
condition ie. only sum the column cells where the above is
true and where the value of the cells in another column
equals 0 or 1 or 2 etc.
What I'm trying to do is derive subtotals of the sum above
based on the revision level where the BA cells are set
to "y". Does anyone have a suggestion?

 

[Frank Kabel]

Hi
try
SUMPRODUCT. e.g.
=SUMPRODUCT(--(BA23:BA500="y"),(BB23:BB500=1),N23:N500)

 

[Frank Kabel]

Hi
make this
=SUMPRODUCT(--(BA23:BA500="y"),--(BB23:BB500=1),N23:N500)

 

[Dale]

Does SUMPRODUCT multiply the values of each array? I'm
not getting any totals when I try your recommendation.
WHat are you indicating with the -- inside the first
parenthesis?
I'll not be able to reply until Monday but thanks for any
suggestions you provide.
Dale

 

[Frank Kabel]

Hi
see my correction. the double minus is required for both
conditions (it coerces the boolean value to real numbers)

 

[Dale]

Excellent, that did the trick.
I really appreciate the help.
Regards,
Dale