Tilted Forum Project Discussion Community  

Go Back   Tilted Forum Project Discussion Community > Interests > Tilted Technology


 
 
LinkBack Thread Tools
Old 09-20-2004, 02:12 AM   #1 (permalink)
Tilted
 
Location: I am not living.
Excel -- How Do I sum varibles lengths of cells

I am creating a spreadsheet for work to establish preping pars, but there is someting I need to do that I don't know how to do in excel.

I have 14 cells in one row. These 14 cells represent two weeks. Each cell contains a number that represents the projected amount of sales for that day.

I have another cell that contains the current day of week (Mon=1, Sun=7)

Now here is where the real problem for me comes. Each item on the spreadsheet has a shelflife ranging from .5 days to 7 days.

So for each item, I need to sum of the projected sales for current day and all the other days that fall in the items shelf life.

For example: I current day was 3 (Wed) and BBQ sauce had a 4 day shelf life. I would need the sum of Wed, Thu, Fri, and Sat projected sales.

For example: I current day was 3 (Wed) and Penne pasta had a 2 day shelf life. I would need the sum of Wed and Thu projected sales.

For example: I current day was 3 (Wed) and Ranch dressing had a 7 day shelf life. I would need the sum of Wed, Thu, Fri, Sat, Sun, Mon, and Tue projected sales.


I know I could do this with messy ifs and choose statements, but I have over 50 items to do this for; I need I cleaner way.

Any help is appreciated
__________________
"Hope is for people that don't stand a chance."
Mavric98 is offline  
Old 10-07-2004, 02:04 PM   #2 (permalink)
Upright
 
Send me an example of your spreadsheet and I will send you a solution back. I use Excel all day long and as such I have a trick or two in this area.
benbun is offline  
Old 10-07-2004, 03:31 PM   #3 (permalink)
Minion of the scaléd ones
 
Tophat665's Avatar
 
Location: Northeast Jesusland
I know I could make it work, I tinker with spreadsheets all day every day, but I am not sure exactly what you want here. Email is your friend.
__________________
Light a man a fire, and he will be warm while it burns.
Set a man on fire, and he will be warm for the rest of his life.
Tophat665 is offline  
 

Tags
cells, excel, lengths, sum, varibles


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -8. The time now is 11:09 PM.

Tilted Forum Project

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2
© 2002-2012 Tilted Forum Project

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76