SUMIF

  • Thread starter Thread starter nick
  • Start date Start date
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?
 
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
 
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)
 
Back
Top