roseysdaddy
New Member
- Joined
- Aug 31, 2006
- Messages
- 2
Ok, basically what I have are two columns. One column lists a store's name that sold a can of soup. The other column lists the date that the store sold it.
What I have now is a COUNTIF statement that reads "=COUNTIF(F6:F41,"Store #1")” that totals up the number of times Store #1 sold a can of soup.
Below that however, I would like to have it broken down by week so I can further tell how many times Store #1 from 7/1/06 through 7/6/06 and below that 7/7/06-7/13/06 and so forth. Can anyone explain how to set this up or point me towards an example?
Thanks!
What I have now is a COUNTIF statement that reads "=COUNTIF(F6:F41,"Store #1")” that totals up the number of times Store #1 sold a can of soup.
Below that however, I would like to have it broken down by week so I can further tell how many times Store #1 from 7/1/06 through 7/6/06 and below that 7/7/06-7/13/06 and so forth. Can anyone explain how to set this up or point me towards an example?
Thanks!