R
Rup1776
Hey
I am trying to count the number of times different initials across 10+
worksheets appear in a specific column.
Basically checking and counting the number of times PGB or RAB or AJC
appears in a specific range (the same range across all the worksheets)
I have managed to do this, however it requires producing some long-winded
formula.
Eg. To count the number of times PGB appears in the range C3-C36 across
several worksheets i have made the formula:
=(COUNTIF('Ward 3'!C3:C36, "PGB")+COUNTIF('Ward 5'!C3:C36,
"PGB")+COUNTIF('Ward 6'!C3:C36,"PGB")+COUNTIF('Ward
7'!C3:C36,"PGB")+COUNTIF('Ward 7'!C39:C72,"PGB")
To make this formula i basically copied and pasted the COUNTIF function
changing the ward number into the formula line.
Is there a better way of doing this?
Second question, I also need to do this for a number of other intials (at
least 20) and I dont really want to keep copying and pasting unless i have
to. Any suggestions?
Thanks
Rup
I am trying to count the number of times different initials across 10+
worksheets appear in a specific column.
Basically checking and counting the number of times PGB or RAB or AJC
appears in a specific range (the same range across all the worksheets)
I have managed to do this, however it requires producing some long-winded
formula.
Eg. To count the number of times PGB appears in the range C3-C36 across
several worksheets i have made the formula:
=(COUNTIF('Ward 3'!C3:C36, "PGB")+COUNTIF('Ward 5'!C3:C36,
"PGB")+COUNTIF('Ward 6'!C3:C36,"PGB")+COUNTIF('Ward
7'!C3:C36,"PGB")+COUNTIF('Ward 7'!C39:C72,"PGB")
To make this formula i basically copied and pasted the COUNTIF function
changing the ward number into the formula line.
Is there a better way of doing this?
Second question, I also need to do this for a number of other intials (at
least 20) and I dont really want to keep copying and pasting unless i have
to. Any suggestions?
Thanks
Rup