ExcelBanter - Can I use OR in SUMIF?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can I use OR in SUMIF? (https://www.excelbanter.com/excel-programming/357148-re-can-i-use-sumif.html)

Jim Thomlinson

Can I use OR in SUMIF?

Check out sumproduct...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson

"iampritzy" wrote:

rFor example: SUMIF(B2:B7, "Apple OR Orange", C2:C7) If it's an apple or an
orange, sum their values in column c.
It does not work. Can anyone help?

All times are GMT +1. The time now is 10:32 AM.