Sumifs and OR statement

[JVID]

Hey All,

In Excel 2007, trying to do a OR statement or multiple conditions. I have large amounts of criteria and only want two or three.

Any advice?

Thanks and have a blessed day

 

[Firefly2012]

Hi

One such way is like this:

=SUM(SUMIFS(SumRange,CriteriaRange1,{"Crit1a","Crit1b","Crit1c","Crit1d"},CriteriaRange2,Criteria2))

The {} is an array constant - this can be a range of cells (single row or single column) holding the values but then you need to enter the formula with Ctrl+Shift+Enter rather than just Enter.