Grand Total, but exclude some accounts

[Warmhearted]

I used formula

SUMIFS(B4:B1200,A4:A1200,"<>",B4:B1200,"<>")

to grand sum below accounts, but can you adjust the formula to exclude certain account such as 120? Thanks!

	164.76​	SUMIFS(B4:B1200,A4:A1200,"<>",B4:B1200,"<>") 164.76 is grand total of 4 accounts
40​	13.95​	21.07.01
40​	17.75​	21.07.01
	31.7​
45​	75.45​	21.07.07
45​	3.5​	21.07.15
45​	9.8​	21.07.15
	88.75​
50​	14.5​	21.07.07
50​	2.8​	21.07.13
	17.3​
120​	12​
120​	15.01​
	27.01​

 

[Eric W]

Try:

=SUMIFS(B4:B1200,A4:A1200,"<>",B4:B1200,"<>",A4:A1200,"<>120")

 

[Warmhearted]

Try:

=SUMIFS(B4:B1200,A4:A1200,"<>",B4:B1200,"<>",A4:A1200,"<>120")

Hi Eric,
It work perfectly.

Could this formula exclude another account in words such as "Target" instead of numbers?

 

[Eric W]

Sure, something like this:

=SUMIFS(B4:B1200,A4:A1200,"<>",B4:B1200,"<>",A4:A1200,"<>120",F4:F1200,"<>Target")

 

[Warmhearted]

Sure, something like this:

=SUMIFS(B4:B1200,A4:A1200,"<>",B4:B1200,"<>",A4:A1200,"<>120",F4:F1200,"<>Target")

Hi Eric,
I changed F in the formula to A and it works perfectly. It your credit! Thanks so much Eric.