Formula help!!

[CLARE83]

Hi,

I have a spreadsheet (see image) in which i want to record attendance %. I want a figure for Tuesday P6 Wednesday P6 and Thursday P6. I need a formula to count how many "/" and "x" (attended) and then one for other codes (not attended,

I just cant seem to work it out - brain block!!!

Thanks in advance

 

[CLARE83]

The answer is probably quite simple but the lack of accuracy and clarity in your question is making it anything but that.

Best guess without a clearer example would be something like

=SUMPRODUCT((LEFT($A$1:$Z$1,3)="Wed")*($A$2:$Z$2="P")*($A$3:$Z$99="/"))

If you click the XL2BB link in my signature block below, it will take you to a guide showing you how to post a clear example.
[/QUOTE

Apologies for the nonsense - one of those days and my brain is not working

 

[CLARE83]

Thank you for your help and again apologies for my lack of clarity

 

[Chewyhairball]

Hi
Apologies but I have to go and take my dogs out. Ill check back after and if you are still looking for an answer ill have a look.
thanks

Rory