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

 

[arthurbr]

Try the COUNTIF function

 

[Chewyhairball]

Hi
How do you want to display these. Do you want a cell showing how many for / and another for x?

simple countif is

=COUNTIF(select range here,"/")

Rory

 

[CLARE83]

Tried countif it brings a error message saying I've entered too many arguments for this function. I only want it to count every 6th cell not all of the cells. I know its simple but i just cant seem to get the basic formula to work!!

 

[Chewyhairball]

I'm not sure I follow you. Every six cell. Row or Column?
thanks

Rory

 

[Chewyhairball]

Are you trying to count / and x together or separately?

 

[jasonb75]

I only want it to count every 6th cell not all of the cells.

From your screen capture it looks like every 3rd cell, does this mean that your cells are merged as well?

 

[CLARE83]

Every 6th Cell in a column and counting them together

 

[CLARE83]

From your screen capture it looks like every 3rd cell, does this mean that your cells are merged as well?

Every 6th Cell in a column and counting them together

I was using every 6th cell as an example,

 

[jasonb75]

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.