Used SUMIF and Division in one Summary Field

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

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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.

Answers