SOLVED

How to unselect the particular values in sumIF statement.

Brass Contributor

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

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@SUDHAKAR-FRONTIER 

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
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@SUDHAKAR-FRONTIER 

Assuming data in Table1 with columns [Product] and [Amt] if you only have one product to exclude:

=SUMIF(Table1[Product],"<>macbook",Table1[Amt])

View solution in original post