Hi,
I'm creating a duty roster type spreadsheet, and I need to create a sum of the number of duties that a person does.
so far, countif(A10:Z10,"X"), counts the number of total duties done per month for each person. However, I need to differentiate between weekday and weekend duties. In a higher row, row 5, there are the days, M, T, W, T, F, S, S in repeating order, to tell which day of the week it is.
Is there any way I can make the countif() (or any other function) so that it reads more like countif(A10:Z10,AND("X"),{2 rows above it}="S")
I'm creating a duty roster type spreadsheet, and I need to create a sum of the number of duties that a person does.
so far, countif(A10:Z10,"X"), counts the number of total duties done per month for each person. However, I need to differentiate between weekday and weekend duties. In a higher row, row 5, there are the days, M, T, W, T, F, S, S in repeating order, to tell which day of the week it is.
Is there any way I can make the countif() (or any other function) so that it reads more like countif(A10:Z10,AND("X"),{2 rows above it}="S")