negative countifs

[Andy83UK]

I am trying to use a formula to count a large number of occurences on a spreadsheet subtracting away a couple of variables, so far I haven't been able to acheive this on a test sheet.

The formula I'm trying to make work is

=COUNTA((B2:B14))-COUNTIFS(B2:B14,"e",B2:B14,"f")

I think that is basically doing what I require as I want to toal up a much larger sheet of a couple of thousand rows of info minusing away any with the criteria of e and f.

Thanks
For your help.

 

[Andy83UK]

thanks I think thats it. Although looking at possibly using pivot tables in place of the formulas now cos this is getting to look like a database not a spreadsheet but i'll use this as back up thank you for your help.