| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Question
Thank you ahead of time for your help and assistance.
I am working on a worksheet right now where I have a column showing the percentage of goal vs. target. I would like to make a formula that would add up all the percentages that are 100% or more over those goals. Currently, I have the following formula but I am not getting an accurate count. =SUMIF(O45:O62,"100%") One example I had 5 goals over 100% and only 3 showed up. One goal was 157% and other was 125% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a tough question - calculating a number out of an alphanumeric code | Excel Discussion (Misc queries) | |||
| Simple Question, Calculating Discounts | Excel Worksheet Functions | |||
| Calculating averages excluding outliers...a question | Excel Worksheet Functions | |||
| Calculating basic averages...a question | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Threaded Mode
