+ Reply to Thread
Results 1 to 2 of 2

We want a formula that will show items sold by the day and the net amount sold on that day

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    1

    We want a formula that will show items sold by the day and the net amount sold on that day

    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.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: We want a formula that will show items sold by the day and the net amount sold on that

    Why not use a countifs to count the items and a sumifs to sum the net sales?

    Post a version of the file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1