Sumifs Help - exclude

[Mr Retirement]

Hello,

I am looking to have a sumifs formula that one of the criteria excludes an item as opposed to include.

=sumifs(L:L,H:H,H3,J:J,J3)

I need to exclude J3 in the above. I know there is a way "<> TEXT" but is there a way to exclude a cell itself not text?

Thanks,
Mr R

 

[Joe4]

Try:

[COLOR=#333333]=sumifs(L:L,H:H,H3,J:J,"<>" & J3)[/COLOR]

 

[Mr Retirement]

thank you joe!

 

[Joe4]

You are welcome.