hello I have a countif formula for multiple cells but do not want to manually type in each cell number is there any way to get them to auto populate for example
=COUNTIF('15Nov'!$C$4:$C$4,"x")+COUNTIF('15Nov'!$C$4:$C$4,"x")
=COUNTIF('15Nov'!$C$5:$C$5,"x")+COUNTIF('15Nov'!$C$5:$C$5,"x")
=COUNTIF('15Nov'!$C$6:$C$6,"x")+COUNTIF('15Nov'!$C$6:$C$6,"x")
and so on?
Solved by X. W. in 29 mins