Formula to count negative periods and periods in between?

ClaireCat

New Member
I currently have a spreadsheet which tells me how many months build period we have, buy calculating how much capex we have, and over what time.
Issue I have is, if people spend X amount one month, and then X amount in 4 months time, my report will pull me off 2 months, whereas it should be 5 (1st spend to last spend) as it took 5 months to build it.

**no idea how to add an image of this, sorry - but here's a link to it! https://drive.google.com/file/d/1rQVKfJbEiQMFMcyGgpQLvUW2vuYqOr2H/view?usp=sharing

You'll see my formula brings back 4, as this is the number of capex items - but I really need it to bring me back 15.

Is there anyway to do this?

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Replies
9
Views
181
Replies
0
Views
32
Replies
0
Views
43
Replies
3
Views
33
Replies
2
Views
34