Forum Discussion
Solved
How to unselect the particular values in sumIF statement.
Hi Friends, Kindly help me how to unselect particular value using SUMIF Function in Excel. I.e Row Dell. Lenovo. Hp. Acer. Macbook. IBM. Asus. So here i dont want take "MACBOOK", Others...
Assuming data in Table1 with columns [Product] and [Amt] if you only have one product to exclude:
=SUMIF(Table1[Product],"<>macbook",Table1[Amt])
Assuming data in Table1 with columns [Product] and [Amt] if you only have one product to exclude:
=SUMIF(Table1[Product],"<>macbook",Table1[Amt])- Thank you L Z its working fine
- You're welcome
