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-04-2024, 05:34 PM

Alansidman Alansidman is offline

Windows 11 Based on Date Entry, Calculate SUM & Percentage

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

Power Query Solution for total. Simple math for the other issue =COUNTIF(Table1[2024 Inspection],"<>"&"")/C31

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([2024 Inspection] <> null)),
    #"Calculated Sum" = List.Sum(#"Filtered Rows"[Principle])
in
    #"Calculated Sum"

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511

« 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.