Based on Date Entry, Calculate SUM & Percentage

		Microsoft Office Forums > Microsoft Excel > Excel
Based on Date Entry, Calculate SUM & Percentage

FAQ

Thread Tools

Display Modes

02-05-2024, 12:42 AM

ArviLaanemets ArviLaanemets is offline

Based on Date Entry, Calculate SUM & Percentage

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

Code:

=SUMIFS(E2:E29,A2:A29,"<>" & "",L2:L29,">0")
and
=COUNTIFS(A2:A29,"<>" & "",L2:L29,">0")/COUNTIFS(A2:A29,"<>" & "",E2:E29,">0")

Btw. Alan
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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:51 AM.