Or condition in SUMIF

[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

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--((A1:A100="abc")+(B1:B100="def")>0),C1:C100)

 

[Domenic]

Hi,

Here's another way...

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

entered using CONTROL+SHIFT+ENTE

 

[Bob Phillips]

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)

 

[Domenic]

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.