Or condition in SUMIF

  • Thread starter Thread starter doggies
  • Start date Start date
D

doggies

Hi, if I have a question,

colA colB colC
abc def 1
abc zzz 2
zzz def 3

how can I sum those with abc OR def and not double counting them.

tk
 
Hi,

Here's another way...

=SUM(IF((A1:A3="abc")+(B1:B3="def"),C1:C3))

entered using CONTROL+SHIFT+ENTE
 
Looks the same to me, just using array formula rather than SUMPRODUCT's
non-array facility.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Some people may be interested in knowing that there's an alternative
available. Also, some people, as in myself, may actually prefer the
array formula.
 
Back
Top