Help
 

I'm trying to do an inventory spreadsheet for my store. Here is the problem.

Example. Mon-x amount Tues-received xamount Wed. xamount Fri.-xamount
Total xamount for week.

basically, an inventory count is done on mondays, wednesdays, and fridays.
I receive a truck on tuesdays. The problem is that I need to show a total
amount of what is in the store on Friday nights. But, I can't figure out the
formula to use where it will subtract mondays, wednesdays, and fridays ending
inventory to show what i have in the store. Plus, along with having received
items. What formula would i use for the "total" column?

Help
 

I don't really understand what is is that you want.

I receive a truck on tuesdays. The problem is that I need to show a total
amount of what is in the store on Friday nights.

Isn't that the inventory count on a Friday?

A

Example. Mon-x amount [ ] Wed. xamount
Fri.-xamount

inventory counts or sales?

amount of what is in the store on Friday nights. But, I can't figure out
the
formula to use where it will subtract mondays, wednesdays, and fridays
ending
inventory

Subract from what?


--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"How do i make a chart" wrote
in message ...
I'm trying to do an inventory spreadsheet for my store. Here is the
problem.

Example. Mon-x amount Tues-received xamount Wed. xamount Fri.-xamount
Total xamount for week.

basically, an inventory count is done on mondays, wednesdays, and fridays.
I receive a truck on tuesdays. The problem is that I need to show a total
amount of what is in the store on Friday nights. But, I can't figure out
the
formula to use where it will subtract mondays, wednesdays, and fridays
ending
inventory to show what i have in the store. Plus, along with having
received
items. What formula would i use for the "total" column?