Results 1 to 5 of 5

Calculating Column Based on 2 Other Columns

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2008
    Location
    Phila, PA
    Posts
    2

    Calculating Column Based on 2 Other Columns

    I apologize if this is a repeated question. Have been searching and not finding exactly what I need.

    I have a spreadsheet that needs to calculate numbers based on two conditions. To give a bit more detail I am trying to calculate chat volume for our office based on the day and hour for an entire month. To complicate it more, I have a sheet with our call log that counts how many chats came in during that hour per day. So I need to know the total number of chats that came in on all Mondays in the month at 8am, for example.

    So in column A I have Sun through Sat, in column B I have "12:00 AM", "1:00 AM, 2:00 AM, etc... In column C I have the number of calls for that day at that hour.

    Where the formulas need to go is another workbook that will be doing the calculations. What I need a formula for is to say "If on sheet 'Call Data' if any cell in column A shows "Mon" and a corrosponding cell on the same row shows "8:00 AM" to add the number that is in column C.

    The end result that I need is to see:

    Mondays at 8:00 AM we have had a total of 27 calls.

    I have attached the data sheet. I have highlighted the cells that I need to calculate. The second sheet is where I need to enter the formulas.
    Attached Files Attached Files

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