|
|
#4
02-06-2024, 07:53 PM
|
|||
|
|||
Thank you so much for your help. This worked great!
Could you be so kind as to explain how these formulas work? =SUMIFS(E2:E29,A2:A29,"<>" & "",L2:L29,">0") =COUNTIFS(A2:A29,"<>" & "",L2:L29,">0")/COUNTIFS(A2:A29,"<>" & "",E2:E29,">0") You mentioned: "I checked the column A - to exclude subtotals." How does checking column A exclude subtotals? Your help is greatly appreciated. Thank you, Karen 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Sum & Percentage Based on Date Entry
|
Karen615 | Excel | 5 | 02-10-2024 08:44 PM |
|
Calculate week in Word document based on date entered into same document
|
ArviLaanemets | Word VBA | 4 | 11-18-2019 12:25 AM |
| Text Form Field -Calculate Percentage | Perk | Word | 5 | 04-18-2016 09:05 PM |
| How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
|
Formula to auto calculate Day of the week based on Date
|
prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |
Windows 11 
Office 2021
Threaded Mode