• 462K Members
• 6,963 Online
• 559K Conversations
SOLVED

Visitor

# Subtract numbers until gone

I have a spreadsheet with 3 points of data.

1. Number to use per week
2. Total number
3. Week breakout

I need to take the number per week starting at week one then for week 2, 3, etc use the same number until the total number has been used.  I have attached an example to show what I am talking about.  Thanks in advanced

1 Reply
Solution

# Re: Subtract numbers until gone

Hi,

The first step is to link the Week1 cell to the Number to subtract per week using this formula:

`=A2`

The second step, use this formula in Week2 and drag it to the right:

`IF(SUM(\$D2:D2,\$A2)<=\$B2,\$A2,IF(\$B2-SUM(\$D2:D2)=0,"",\$B2-SUM(\$D2:D2)))`

Regards,

Haytham

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies