Function Help

haley.harris

Hello,

I have a sheet set up with a form to track historical data for collections efforts daily. On the Summary tab I'd like it to be able to display today's stats. I'm not sure what function to use to make this happen.

How it is set up is column "A" is the date and column "B" is a percentage. I would like the summary to display if A7 is today's date, it gives the information that is in B7.

Thank you,

Andrée Starå

Hi Haley,

Try something like this.

=SUMIF(A:A; TODAY(); B:B)

The same version but with the below changes for your and others convenience.

=SUMIF(A:A, TODAY(), B:B)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD