Forum Discussion

SUDHAKAR-FRONTIER

Brass Contributor

Jun 18, 2021

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 i have to take values

Lorenzo
Jun 18, 2021
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])

3 Replies

Lorenzo
Silver Contributor
Jun 18, 2021
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])
- SUDHAKAR-FRONTIER
  Brass Contributor
  Jun 18, 2021
  Thank you L Z its working fine
  - Lorenzo
    Silver Contributor
    Jun 18, 2021
    You're welcome

Resources