|
|
#3
02-05-2024, 12:42 AM
|
|||
|
|||
Or
Code:
=SUMIFS(E2:E29,A2:A29,"<>" & "",L2:L29,">0") and =COUNTIFS(A2:A29,"<>" & "",L2:L29,">0")/COUNTIFS(A2:A29,"<>" & "",E2:E29,">0") OP doesn't use defined Table, and has manually put subtotals into table (practically created an paper document in Excel!). This is the reason I checked the column A - to exclude subtotals. 
|
| 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 8 
Office 2016
Threaded Mode