Used SUMIF and Division in one Summary Field

Andrea Westrich

I have used the SUMIF with TODAY to sum the last seven days of a column and that works great. Now I want to calculate a simple percentage of 2 columns for the last seven days. So if I have a column that has a count of "Appt Set" and a count of "Appt Held" each day, I want an ongoing calculation (I never have to update) that gives me a percentage of appointments held for the last 7 days. Can that be done in one Summary field so I can add it to a Dashboard? If so, what is that formula? Is there a better way to do this?

Thanks

Paul Newcome

You would use the same SUMIF statements that you are currently using to get your total for Set and your total for held. Then you would divide set by held. Or maybe held by set is the right way to go to get a percentage. My coffee needs a refill. Haha.

Either way it is simply one SUMIF divided by the other. So just drop in whatever SUMIF you said you were already using to pull the total.

Paul Newcome

Yes. You would use something along the lines of...

=SUMIF([Appt Set]:[Appt Set], ...............) / SUMIF([Appt]:[Appt Held], .........)

Andrea Westrich

Thank you @Paul Newcome! How would I add in only calculating the last 7 days to this formula?

Paul Newcome

You would use the same SUMIF statements that you are currently using to get your total for Set and your total for held. Then you would divide set by held. Or maybe held by set is the right way to go to get a percentage. My coffee needs a refill. Haha.

Either way it is simply one SUMIF divided by the other. So just drop in whatever SUMIF you said you were already using to pull the total.

Andrea Westrich

@Paul Newcome, That worked. I tried it before and it did not, so I'm sure it was just a spacing issue! LOL.

Thanks for your help!

Paul Newcome

Happy to help. 👍️