Results 1 to 9 of 9

Sum Product - Months, Year Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Sum Product - Months, Year Criteria

    I want to sum each month's food costs for a particular year (N4:N15). N4:N15 will be referencing columns A, E and I and summing the costs from columns B, F and J.

    Not sure if there is a function or way to translate month abbreviations so that they filter and match the raw data being entered in. For example, Aug = 18-Aug. I was using the MONTH() function but the abbreviation does not convert the month to a number but the raw data date does. Please advise. Do not go by the current formula in N11, I want to add Breakfast, Lunch and Dinner for any given month out of the year.

    Regards,
    T86157
    Attached Files Attached Files
    Last edited by T86157; 08-21-2012 at 09:47 AM.

Thread Information

Users Browsing this Thread

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

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