Jun 17 2021 10:30 PM
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 i have to take values
Jun 17 2021 11:14 PM
SolutionAssuming data in Table1 with columns [Product] and [Amt] if you only have one product to exclude:
=SUMIF(Table1[Product],"<>macbook",Table1[Amt])
Jun 17 2021 11:33 PM
Jun 17 2021 11:14 PM
SolutionAssuming data in Table1 with columns [Product] and [Amt] if you only have one product to exclude:
=SUMIF(Table1[Product],"<>macbook",Table1[Amt])