In Column "B" i need to sum up column "A" from the row following the "P" in column "C" up to the next occurrence of "P".
A B C
1 € 30,00 P
2 € 5,00
3 € 20,00
4 € 20,00
5 € 25,00 P If C1="" sum(A1:A5) - if C1="P" sum A2:A5
6 € 20,00
7 € 20,00
8 € 2,50
9 € 10,00 P If C5="" sum(A1:A9) - if C5="P" sum A6:A9
10 =SUM(A1:A9)
I need to find the previous "P" row at any time in column "C" and start sum of column "A" from there.
Hope this makes sense.
I've done it before but forgot what i did.
I've been trying for months but my brain is fried and contaminated with all the solutions i came up with.
Is there a KIND soul out there that can help me out?
Thank You
A B C
1 € 30,00 P
2 € 5,00
3 € 20,00
4 € 20,00
5 € 25,00 P If C1="" sum(A1:A5) - if C1="P" sum A2:A5
6 € 20,00
7 € 20,00
8 € 2,50
9 € 10,00 P If C5="" sum(A1:A9) - if C5="P" sum A6:A9
10 =SUM(A1:A9)
I need to find the previous "P" row at any time in column "C" and start sum of column "A" from there.
Hope this makes sense.
I've done it before but forgot what i did.
I've been trying for months but my brain is fried and contaminated with all the solutions i came up with.
Is there a KIND soul out there that can help me out?
Thank You