Pull in totals for Today & Yesterday via a link

LLaCosta

We have (1) sheet that is used for basic data entry. No formulas or anything complicated. The user enters the date, start time, end time and categorizes the work they are doing by selecting a single category every task they complete. There are about 7 categories the user can choose from.

In an effort to not disturb the form as users are actively editing, I linked the 7 category types into a separate sheet and created a "countif" formula in a separate column to get the total # of each category.

However, I only want it to count for a single date. And possibly, just have it pull in the count for "today" and "yesterday".

Suggestions?

Ryan Kramer

@LLaCosta ,

You could use the COUNTIF() and TODAY() functions to get the sum of the counts per your requirement.

Ryan

Paul Newcome

You are going to want something that looks along the lines of...

=COUNTIFS({Source Sheet Category Column}, "Specific Category or Cell Reference", {Source Sheet Date Column}, @cell = TODAY())

and

=COUNTIFS({Source Sheet Category Column}, "Specific Category or Cell Reference", {Source Sheet Date Column}, @cell = TODAY(-1))

LLaCosta

Thanks guys -- i keep getting #unparesable -- is that by chance that it needs a place to reference what today is? I tried to put in that reference -- but failed as well.

Paul Newcome

Can you provide a screenshot of the formula in the sheet similar to below?