Forum Discussion
Using Countif across multiple sheets with a different range
Okay so I want to automatically show the attendance figure for a class per week & I want the attendance to automatically update. I have 4 sheets for 4, 4 week periods. I have been able to update the ...
Shouldn't it be
=COUNTIF('Sheet1'!$E2:$02,"p")+COUNTIF('Sheet2'!$E2:$F5,"p")
Please note that $02 must be a typo.
Thanks for the help, yes that countif function worked. Just a follow up if possible. It is working in terms of counting correctly. However, when I am changing it to percentage it is giving me 900% rather than 90%. So I have 9/10 days attendance & dividing across the whole sum by the amount of possible days is still giving me figures far outweighing the 90%.
Could you attach a small sample workbook demonstrating the problem?