OR function in SUMIFS

**shg** · 05-09-2012, 12:11 AM

=sum(countif(a1:a20, {"a","b","c"}))

**skysurfer** · 05-09-2012, 12:34 AM

shg,

How will COUNTIF will generate the sum? Assuming you meant SUMIF, can I use cell references for A, B and C. And since there are multiple conditions can I use SUMIFS?

Thanks!

Lawrence

**skysurfer** · 05-09-2012, 12:46 AM

shg,

Okay, making progress!

Got your formula to work using constants A, B and C SUM(SUMIFS) function combo. But how do I use cell references instead of constants???

Lawrence