•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Additional condition to check if the day worked is a Friday throws an Err502
Our take
If you're managing a work spreadsheet with two shifts per person, tracking how many Fridays someone has worked can be a challenge, especially when an additional condition leads to an Err502. Currently, you can count total worked days using COUNTIFS(B3:AF6,"<>"). However, adding the condition to check for Fridays with COUNTIFS(B3:AF6,"<>", $B$1:$AF$1,"Friday") triggers an error. To resolve this, consider revisiting your formula structure to ensure it accurately captures the intended data without errors while maintaining clarity and functionality in your spreadsheet.
I am creating a work Spreadsheet with 2 shifts per person. Everyday, I will enter which shifts were worked. At the end of the month I need it to tell me how many Fridays someone has worked.
I can count how many days someone has work. But the additional condition to check if the day worked is a Friday throws an Error.
Days of the week are the top most row on the sheet and pulled with the TEXT function from the date.
COUNTIFS(B3:AF6,“<>“) returns the worked days
COUNTIFS(B3:AF6,“<>“ , $B$1:$AF$1,“Friday“) gives Err 502
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#financial modeling with spreadsheets#rows.com#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#Excel compatibility#row zero#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#Excel alternatives for data analysis#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#Excel alternatives#spreadsheet API integration#COUNTIFS#Excel#work Spreadsheet