Results 1 to 13 of 13

Simpler solutions than sumifs

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-01-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    182

    Simpler solutions than sumifs

    Hi All,

    I have a daily report in which we record all the activities that we do for all the clients by the team members. Now a team member may handle upto 5 clients in a day. Each client may have upto 4 activities. I want a total of all the activities unit per client wherein i take the job ID as the base. I have done that using the SUM of SUMIFS, however i have to use SUMIFS with two criteria 20 times. Is there a simpler solution to this. I am attaching a sample sheet for your reference. I have not used the entire formula in the sample sheet.

    Cheers
    Attached Files Attached Files

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