Some help would be greatly appreciated, I'm looking for the correct formula to tally up my staff's sleeping in shifts (columns Y & Z) so that I can show the accumulation of each staff's individual number sleep shifts in the row 37.
Mac mini, macOS 15.5
If I understand the ask correctly, columns Y and Z indicate the staff's initials, and that matches the values in row 1, right?
You then want row 37 to count how many shifts are assigned to each individual?
That's easy using COUNTIF()
COUNTIF() takes a range (in this case Y:Z for those two columns), and a condition (in this case the value of the cell in row 1) and returns the number of matches:
set C37 to:
=COUNTIF($Y:$Z,C$1)
and fill across the row.
If I understand the ask correctly, columns Y and Z indicate the staff's initials, and that matches the values in row 1, right?
You then want row 37 to count how many shifts are assigned to each individual?
That's easy using COUNTIF()
COUNTIF() takes a range (in this case Y:Z for those two columns), and a condition (in this case the value of the cell in row 1) and returns the number of matches:
set C37 to:
=COUNTIF($Y:$Z,C$1)
and fill across the row.
JJLNGRD23 wrote:
tally up my staff's sleeping in shifts (columns Y & Z) so that I can show the accumulation of each staff's individual number sleep shifts in the row 37.
By "tally up" do you mean count. If so consider using COUNTIF or COUNTIFS.
Recommend minimizing the use of merged cells.
SG
See now this is why I love the apple community, coming together to help
each other out.
I like to think I’m not an idiot but the ease in which you’ve explained this makes me feel it…haha
thanks so much, very much appreciated 🙏🏻
Planning TimeSheets for Work - Struggling with formulas
