count occurances of letter across pages

  • Thread starter Thread starter cake123
  • Start date Start date
C

cake123

Can you tally the number of times a value occurs across a range on a
page, across a number of pages?

i've got a 10 week schedule, with each week on its own page. each page
is identical, with b2 to b8 representing the work week, a cell for each
day of the week.

if i have an employee call in sick of take a vacation day i indicate it
by a V or S in that employees cell for that day.

what i am trying to get is a summary page (page11) that would tally up
all the S days and all the V days for each employee.

can this be done?
 
What are your sheet names?

You could put them (the sheet names) in a range like

A2:A11 on the summary sheet and then use


=SUMPRODUCT(COUNTIF(INDIRECT("'"&A2:A11&"'!B2:B8"),"V"))

for "V"

or use

=COUNTIF('first'!B2:B8,"V")+COUNTIF('second'!B2:B8,"V")+and so on for all 10
sheets
 
Back
Top