Hi
is there any way i can calculate 4 & 12 week sales as per highlighted columns on the attached doc for each product code listed (use the date column to lookup the date range re 4& 12 weeks...)
thanks
Hi
is there any way i can calculate 4 & 12 week sales as per highlighted columns on the attached doc for each product code listed (use the date column to lookup the date range re 4& 12 weeks...)
thanks
The ranges need to be the same size; for example:
=COUNTIFS(H8:H16,H8,D8:D16,">"&DATE(2012,11,29))
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi,
this works ok if the date is manually typed into the cell, but i need a formula that automatically calculates the 4/12 weeks using the date column.... any ideas??
Yes, use the date column ... I was just replicating what you had but trying to make it more obvious and readable as a date ... hence using the DATE function.
=COUNTIFS(H8:H16,H8,D8:D16,">"&DATE(2012,11,29))
could be:
=COUNTIFS($H$8:$H$16,$H8,$D$8:$D$16,">"&$E8)
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks