Hi there,
Ok so...
The 14th, 15th and 17th I would like counting the number of "P"'s there are, divided by the number of cells containing "something". I have this set up nicely for previous weeks, however I've become stuck now that the days I want are non-consecutive.
Previous weeks I use the formula: =IF(COUNTA(BN3:BR3),(COUNTIF(BN3:BR3,"P")+COUNTIF(BN3:BR3,"L"))/COUNTA(BN3:BR3)*100,"")
Now I'm looking at something along the lines of: =IF(COUNTA(BT3:BU3,BW3),(COUNTIF(BT3:BU3,BW3,"P")+COUNTIF(BT3:BU3,BW3,"L"))/COUNTA(BT3:BU3,BW3)*100,"")
It would appear they don't like the comma before the "P" and "L"
The cell under Week 13 % is where the formula should be going.
Thanks in advance folks
Ok so...
The 14th, 15th and 17th I would like counting the number of "P"'s there are, divided by the number of cells containing "something". I have this set up nicely for previous weeks, however I've become stuck now that the days I want are non-consecutive.
Previous weeks I use the formula: =IF(COUNTA(BN3:BR3),(COUNTIF(BN3:BR3,"P")+COUNTIF(BN3:BR3,"L"))/COUNTA(BN3:BR3)*100,"")
Now I'm looking at something along the lines of: =IF(COUNTA(BT3:BU3,BW3),(COUNTIF(BT3:BU3,BW3,"P")+COUNTIF(BT3:BU3,BW3,"L"))/COUNTA(BT3:BU3,BW3)*100,"")
It would appear they don't like the comma before the "P" and "L"
The cell under Week 13 % is where the formula should be going.
HS | HS | ||||
14/06 | 15/06 | 16/06 | 17/06 | 18/06 | Week 13 % |
P | P | UA | P | UA | #N/A |
Thanks in advance folks