Planning TimeSheets for Work - Struggling with formulas


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

Posted on May 27, 2025 1:41 PM

Reply
3 replies
Sort By: 

May 27, 2025 7:23 PM in response to JJLNGRD23

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.


COUNTIF - Apple Support

COUNTIFS - Apple Support


Recommend minimizing the use of merged cells.


SG


Reply

Jun 2, 2025 10:23 AM in response to JJLNGRD23

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.


Reply

Planning TimeSheets for Work - Struggling with formulas

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.