SUMIF

N

nick

I can use SUMIF with one range but I wish to calculate a
sum based on relevant criterea in two ranges. I have tried
=SUM(IF((A1:A10=1)*(C1:C10=1),F1:F10,0)) and although the
formula result in the formula bar gives me the answer I
require (in the live example 114), the cell in which the
formula is typed gives a zero value. Any thoughts?
 
P

Peter Atherton

Nick

Your formula works fine on my test data. Are you sure that
the answer is not zero, or that the criteria are correct?

Regards
Peter
 
B

Bob Phillips

Nick,

It is an array formula, so commit with Ctrl-Shift-Enter, not just enter.

You could also use

=SUMPRODUCT((A1:A10=1)*(C1:C10=1),F1:F10)

which is not an array formula.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top