Hi,

I want to use a countif function, counting values in column 1-9, The next countif function needs to count values in column 10-18 etc..
As i have 4000 columns to count and don want to key in 450 times the same countif statement (except different columns to count) I wonder if there is an easy way to automate the countif statement so i can key it in once and copy and paste it 449 times.

Hope someone has an easy solution for me?