CODEWITHSUNDEEP
excelformulacountif
Drawleeh
Drawleeh

Reputation: 259

Excel Dynamic Countifs range

Can a countifs range be dynamic?

I'm simply trying to do a countifs formula in a worksheet that is likely to grow, currently I have the upper bound set to 10000 but since I'm trying to count the number of instances a date appears in a list I have to have a countif formula for every single day of the year. Thats 365 countif formulas all with an upper bound of 10000 and I'm sure at some point in a few months I will have to update it.

Am I able to use Excel formulas much like I could in VBA to declare a dynamic range for my countifs function?

Example of Spreadsheet

Upvotes: 0

Views: 325

Answers (1)

ApplePie
ApplePie

Reputation: 8942

If you convert your cell range to a table (select your table then Insert > Table) you can refer to the entire column or row with your formula and it will adapt dynamically.

Upvotes: 0

Related Questions