Formula to count how many people will be in the office specific day(s)

Dina Dekhi

I have 2 sheets and I'm trying to populate how many people will be in the office on specific days. One sheet has the specific date(s) and where the sum value should be and i need to gather from another sheet who is coming in on the specific days. I tried formulas but kept getting an error.

Paul Newcome

You should be able to get away with something like this...

=COUNTIFS({Form Sheet Date Column}, Date@row)

Paul Newcome

Are you able to post some screenshots with sensitive/confidential data removed, blocked, and/or replaced with mock data as needed?

Dina Dekhi

Of course. Basically this spreadsheet will have the departments and specific dates that assigned. (Date column being important factor)

The forms that will be filled out will be on another sheet we will need to reference from.

Once someone fills in the specific date on the form that is created I would like the "Amount in Office" on the 1st spreadsheet to Sum up

Ex. If 4 people from Finance come in Sept 10th the Amount in Office will increase by 4 automatically referencing from the other sheet.

Hope that makes sense.

Thank you!

Paul Newcome

You should be able to get away with something like this...

=COUNTIFS({Form Sheet Date Column}, Date@row)

Dina Dekhi

Worked! thank you!

Paul Newcome

Happy to help. 👍️