Hi,

Is there a way to include the OR function--or functionality--in SUMIFS criteria? I am looking for a range to satisfy three criteria: = A OR B OR C.

I was able to build that functionality into SUMPRODUCT (thanks to excelforum!), but my goal is to optimize performance and replace all the SUMPRODUCT functions.

Thanks,

Lawrence