Break up Countifs, and reffer to each part in formula

orjanmen

New Member
Joined
May 21, 2014
Messages
25
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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,414
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
Care to post the COUNTIFS formula that you have and spell the additional criterion that you want to apply?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,525
Messages
5,523,377
Members
409,514
Latest member
MarkZuckerberg

This Week's Hot Topics

Top