Results 1 to 8 of 8

=Sum Problem

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2015
    Location
    lancashire
    MS-Off Ver
    2013
    Posts
    4

    Red face =Sum Problem

    I'm trying to get a spreadsheet document to calculate via =SUM of a total column, to generate this column data it comes from the previous column next to it with the formula "=IF(G2="200",+D2,"")" All this is doing is if the cell G2 is the extension "200" being one of our call centre staff ex.number, it then puts the "call duration" in the cell in and if any other extension in there, it wont include it and they can be a new formula in a different column.

    Because the data is imported from our VOIP data source the formulas in the columns work only when the data arrives, so all the blank fields under it are they show as #Value
    and =SUM wont work if that's in a field.



    What I'm trying to is a total of call time per Ext.number, as I've solved a way to calculate the call amount, i just cant find a way to get the call duration so we can display it on a TV on our wall to motivate staff
    Ext 200 = 74 Calls total
    Ext 200 = 784 Total Call Duration

    Ext 201 = 97 Calls total
    Ext 201 = 854 Total Call Duration

    Please see attached picture to get a better understanding of my problem, I'm sure there are very clever ways to solve it but this is the only way i can work out a way to get it to work.

    Here is the file, its 37mb so it wont upload.
    http://wikisend.com/download/440042/Call Report.xlsm
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  2. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  3. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  4. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  5. Started out as an Access problem. Now an Excel problem
    By RobertM in forum Excel General
    Replies: 2
    Last Post: 04-26-2006, 02:35 PM

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