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

TEST.xlsx (23.8 KB, 5 views)

Is this what you're after?:
2022-11-26_193354.png
See attached.

Attached Files

msofficeforums50046TEST.xlsx (40.0 KB, 5 views)

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%

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.

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

TEST.xlsx (25.1 KB, 6 views)

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

msofficeforums50046TESTv2.xlsx (44.0 KB, 3 views)

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

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.

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