M
Michael Saffer
Hello everyone,
My problem is with counting totals of a product sold throughout the year. I
need totals in 3 different categories, sales on all Monday-Friday days,
sales on all Saturday days, and sales on all Sunday days. There are 365
rows in my sheet. The rows are setup similar to this:
Date Count Day
4/1/03 117 Tuesday
4/2/03 136 Wednesday
4/3/03 115 Thursday
4/4/03 125 Friday
4/5/03 130 Saturday
4/6/03 111 Sunday
4/7/03 114 Monday
4/8/03 116 Tuesday
4/9/03 124 Wednesday
The list goes on like this for a full year. If this was the only list to
count, I would just do some sorting and wade through the data to get some
totals but I have hundreds of these to do, all on separate sheets. Ack!
Could someone assist me with a formula that will give me 1 total for all M-F
sales, Sat, and Sun?
Many thanks in advance.
Best,
M Saffer
My problem is with counting totals of a product sold throughout the year. I
need totals in 3 different categories, sales on all Monday-Friday days,
sales on all Saturday days, and sales on all Sunday days. There are 365
rows in my sheet. The rows are setup similar to this:
Date Count Day
4/1/03 117 Tuesday
4/2/03 136 Wednesday
4/3/03 115 Thursday
4/4/03 125 Friday
4/5/03 130 Saturday
4/6/03 111 Sunday
4/7/03 114 Monday
4/8/03 116 Tuesday
4/9/03 124 Wednesday
The list goes on like this for a full year. If this was the only list to
count, I would just do some sorting and wade through the data to get some
totals but I have hundreds of these to do, all on separate sheets. Ack!
Could someone assist me with a formula that will give me 1 total for all M-F
sales, Sat, and Sun?
Many thanks in advance.
Best,
M Saffer