COUNTIF Help

[dkflameboy]

Hi, I need to calculate in cell K5 how many times "Y" appears in cells D5, F5, H5 and J5 so that I can then use this total to calculate how much money has been paid in Cell L5 (that last calculation I can do. what is the formula I need to use to count the number of times "Y" appears in the above Cells?

By the Way, Y will only appear once in each cell.

Many thanks

 

[Joe4]

One way:
=(D5="Y")+(F5="Y")+(H5="Y")+(J5="Y")

 

[dkflameboy]

One way:
=(D5="Y")+(F5="Y")+(H5="Y")+(J5="Y")

perfect, thank you