Formula to Match cross sheet and COUNT instances.

Ersellix

Hello Smartsheet Community!

I'm trying to create a formula that generates an integer value based on two criteria.

I have one sheet that acts as a repository for all of the daily activity at multiple sites, for each day of the year.

My formula needs to MATCH [Date@row} to the cross sheet reference range {Master Shipment Log - Date}. For all instances with a matching date the formula then checks the {Master Shipment Log - Site} and counts all instances that Match the individual sites.

Since this is checking 2 conditions would this require an INDEX(COLLECT instead of INDEX formula?

Paul Newcome

It sounds more like a COUNTIFS.

https://help.smartsheet.com/function/countifs