PLEASE HELP!!!!
We have an hourly sales performance report that shows items sold per day. We want a formula that will show items sold by the day and the net amount sold on that day. Each dish per day has different net sales amount so we need some kind of count plus sum formula that will find the dish by the day and total the net sales amount for that day.
We were using this =COUNTIFS('Jan Sorted'!G:G,"4/5/2012",'Jan Sorted'!C:C,A12)
but we realized that the hourly sales performance report showed different net amounts per dish so we could no longer count the item sold and multiply it by the gross amount to determine our gross sales.
Bookmarks