This could be really simple...
What is the best way (formula or other..) That would do a count of say "S" depending on the name of the person in "Cell x" on different sheets in the same work book.
I was thinking a Vlookup/count if formula but just wondering the best way to contruct it.
I have this in place already
=COUNTIF('2017-18'!KG9:LK9,"S") - (This is counting all the S's in during that particular month
but i want it to do the formula based on the name in say cell C6
Thanks
What is the best way (formula or other..) That would do a count of say "S" depending on the name of the person in "Cell x" on different sheets in the same work book.
I was thinking a Vlookup/count if formula but just wondering the best way to contruct it.
I have this in place already
=COUNTIF('2017-18'!KG9:LK9,"S") - (This is counting all the S's in during that particular month
but i want it to do the formula based on the name in say cell C6
Thanks