Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a document that I basically use only to track whether specific weekly
or monthly reports have been submitted. I need to know the percentage of each report submitted for both the current month and for the year. I've been having it return percentages by using: counta(range)/(counta(range) + countblank(range)) I fill down the column of specific reports and get accurate percentages per report. Is there a simpler way to do this? Each week I update the range in the first cell to include the current week and fill down. That works for me, but my supervisor believes there has to be a more elegant solution. It seems to me that there should be as well, and If there is, I'd rather use it. If there isn't, the solution we have works well enough, I guess. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
How to write a formula to show the "last date" of a month | Excel Worksheet Functions | |||
If date is in the month of Sept, then "1", otherwise "2" | Excel Worksheet Functions | |||
Working out age from "Day" "Month" "Year" | Excel Worksheet Functions | |||
How do make input date by "month/day" in Excel? | Excel Discussion (Misc queries) |