Break up Countifs, and reffer to each part in formula

[orjanmen]

Merry Christmas, everybody.

I have a sheet with about 50 countifs. Theese countifs contain 7-8 criterias. 6-7 of theese criterias are identical. Now I want to add another criteria. The way I do it today, it means alot of copy-paste.

So, is it possible to write each of the criterias in a cell, and then just reffer to the cell in the countifs?

Also, I guess it might exist an easier solution to this, but this is what I'm able to figure out by myself with my Excel skills

Thanks.

 

[mrshl9898]

You can put the Range (Say A:A) in a cell (B2) and the criteria in another (C2), then use =COUNTIF(INDIRECT(B2),C2)

 

[Aladin Akyurek]

Care to post the COUNTIFS formula that you have and spell the additional criterion that you want to apply?