Display Calls Made Today

Andrea Westrich

I want to do something simple but can't seem to figure it out. In a summary, I want to display the number of "Calls Made" for the current date. In other words, I want to display the number entered in the "Calls Made" column for today. Which function would work best for that?

Thanks

Mark Cronk

You'll use SUMIF or COUNTIFS.

=COUNTIFS([Calls Made]:[Calls Made], [date]:[date:], Today())

Where [date] is the name of your column. If calls made is a number then you'll want to use =SUMIF( instead.

Help?

Mark

Mark Cronk

You'll use SUMIF or COUNTIFS.

=COUNTIFS([Calls Made]:[Calls Made], [date]:[date:], Today())

Where [date] is the name of your column. If calls made is a number then you'll want to use =SUMIF( instead.

Help?

Mark

Andrea Westrich

Thank you, Mark. That worked perfectly!

Mark Cronk

Glad to help. Thank you for contributing to the Community.

Mark