Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2022, 09:21 AM
rammy25 rammy25 is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2021
Novice
Sum by month according to percentage and dates
 
Join Date: Nov 2022
Posts: 5
rammy25 is on a distinguished road
Default Sum by month according to percentage and dates

Hey, if anyone can help me with this because I can't manage, I try to make the sum per month for some length that are put by dates in column 50%, 90%, 100%.

There is a formula to calculate this?

Thank you
Attached Files
File Type: xlsx TEST.xlsx (23.8 KB, 5 views)
Reply With Quote
  #2  
Old 11-26-2022, 12:35 PM
p45cal's Avatar
p45cal p45cal is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2019
Expert
 
Join Date: Apr 2014
Posts: 695
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

Is this what you're after?:
2022-11-26_193354.png
See attached.
Attached Files
File Type: xlsx msofficeforums50046TEST.xlsx (40.0 KB, 5 views)
Reply With Quote
  #3  
Old 11-26-2022, 01:26 PM
rammy25 rammy25 is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2021
Novice
Sum by month according to percentage and dates
 
Join Date: Nov 2022
Posts: 5
rammy25 is on a distinguished road
Default

It's something like this, but the pivot not returning correct values because for one thing done 100% in november and 90% in august you should have only 10% in november but pivot take 100%
Reply With Quote
  #4  
Old 11-26-2022, 02:34 PM
p45cal's Avatar
p45cal p45cal is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2019
Expert
 
Join Date: Apr 2014
Posts: 695
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

You'd best put values calculated manually in the grid so that we can try to reproduce.
It would also help to put some simple calculations in some cells so we can see how you arrive at some of those values.
Reply With Quote
  #5  
Old 11-26-2022, 03:16 PM
rammy25 rammy25 is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2021
Novice
Sum by month according to percentage and dates
 
Join Date: Nov 2022
Posts: 5
rammy25 is on a distinguished road
Default

Here is the excel with some formula Sumifs by criteria of dates that I calculate for november but if I go back to october, june I loose track of everything
Attached Files
File Type: xlsx TEST.xlsx (25.1 KB, 6 views)
Reply With Quote
  #6  
Old 11-27-2022, 07:00 AM
p45cal's Avatar
p45cal p45cal is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2019
Expert
 
Join Date: Apr 2014
Posts: 695
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

OK. It looks quite complicated! I've not got my head around it yet.
Maybe it would help me if you can you say, in words, what the results intend to show, and perhaps, for a bit of context, what this data represents in the real world.
And maybe take one row (say row 13, index 12) and say what has happened on/by each of the 3 dates?
I'm guessing these dates might be the date by which 50%, 90% and 100% of the lengths (of pipe?, railway?) were completed?


Anyway, another guess, but the results are different from yours:


2022-11-27_135920.png
Attached Files
File Type: xlsx msofficeforums50046TESTv2.xlsx (44.0 KB, 3 views)
Reply With Quote
  #7  
Old 11-27-2022, 07:57 AM
rammy25 rammy25 is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2021
Novice
Sum by month according to percentage and dates
 
Join Date: Nov 2022
Posts: 5
rammy25 is on a distinguished road
Default

Yes, on rows are piping length and on column the progress

for example for row 13(12)
Lenght: 12.61
on 25.08.2022 was done 50% so 6.305 ml
on 26.08.2022 was done 90% from total so 0.9from total lenght: 11.631ml but without the 6.8 ml that was done before so the result is 5.044

so in the future for 100% it remains to be done 1.261 ml

this is an extract from a larger data base that is export like this and I would like to calculate how many meters was done per month
Reply With Quote
  #8  
Old 11-27-2022, 09:17 AM
p45cal's Avatar
p45cal p45cal is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2019
Expert
 
Join Date: Apr 2014
Posts: 695
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

So the last file I attached seems to be correct?
Here's that pivot filtered for just index 12:
2022-11-27_161422.png
I've added grand totals for rows as well so that you can see the total length tallies.
The values for August and October seem to be right too.
Reply With Quote
  #9  
Old 11-27-2022, 11:52 AM
rammy25 rammy25 is offline Sum by month according to percentage and dates Windows 10 Sum by month according to percentage and dates Office 2021
Novice
Sum by month according to percentage and dates
 
Join Date: Nov 2022
Posts: 5
rammy25 is on a distinguished road
Default

But in the excel if you will put filter 50%, 90%, 100% in november you should have for 100% 175 ml??? I didn't check for grand total if it,s correct but I will check
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.) kingmb Excel 2 09-11-2018 01:08 AM
Sum by month according to percentage and dates Sort data by month and by dates Marcia Excel 4 05-30-2018 01:51 AM
X axis graph all dates when date column contains specific dates..possible ? DBenz Excel 2 03-28-2018 04:59 AM
Autofill dates - how can I get the same date and consecutive dates? Exhale Excel 3 04-05-2016 03:11 AM
start-stop month dates in calendar madison320 Project 0 06-24-2011 08:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft