Formula for counting how many people have signed in each month, referencing another sheet?
I am trying to count how many people have signed in for each month referencing another sheet so that the number appears on my metrics sheet. The below is what I have at the moment but it isn't working:
Trying to find how many people signed into Yard A in January 2023:
=COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1, {Yard A Date}, IFERROR(YEAR(@cell), 0) = 2023, COUNTIFS({Signed in}, [Primary Column]:[Primary Column], @cell = "Signed in"))
#UNPARSEABLE
I have also tried:
=COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1, {Yard A Date}, IFERROR(YEAR(@cell), 0) = 2023, {Signed in}, @cell = "isnotblank")
returning a value of 0, which is incorrect it should be 254
I also plan to add more yards to this formula, I figure once I've got it right with one I can + and duplicate for the others.
Can anyone help with this formula I think its the referencing another sheet is stuffing me up here?
Answers
-
Have also tried:
=COUNTIFS({Yard A Date}, IFERROR(MONTH(@cell), 0) = 1, {Yard A Date}, IFERROR(YEAR(@cell), 0) = 2023, {Signed in}, NOT(ISBLANK(@cell)))
But its also returning a value of 0
-
How exactly is your {Yard A Date} range being populated, and do you have the column formatted as a date type column?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!