Sum If meets criteria X but do not include if it includes Y

[Fish55]

Hi,

I am looking to sum up a total area depending on two pieces of criteria, I know that you can use the SUMIFS function to do this but I was wondering if it is possible to make the formula only pick up certain lines based on what has been entered in another column.

To help make my question clearer I have attached a example.

In the example I want to add up column C (AREA) and great a total against the ID numbers in column B. However I do not want to count any that are noted as cancelled which is stated in column D (STATUS).

Any help is appreciated.

Thanks

[gue2013]

SumIFs supports more than one criteria

Please Login or Register  to view this content.

drag it down

cheers,
Guenter

[Sam Capricci]

try sumifs for that... =SUMIFS($C$4:$C$12,$B$4:$B$12,"ABC",$D$4:$D$12,"<>cancelled")

[Fish55]

Thank you to you both!

Can I ask though, does the "<>" just mean to not include if it includes....whatever you put after?

Just for my own knowledge in the future.

[Sam Capricci]

yes, this "<>cancelled" means exclude each cell in column D that contains cancelled.

[Fish55]

Great! thanks again