+ Reply to Thread
Results 1 to 5 of 5

Calculating totals from groups using defined lists

Hybrid View

  1. 11-13-2007, 09:56 AM #1
    corinereyes
    corinereyes is offline
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2016
    Posts
    520
    Welcome to the forum:

    Try the following:

    on D12 = =SUMPRODUCT(--(ISNUMBER(SEARCH("100", D2:D8))),C2:C8)
    on D13 = =SUMPRODUCT(--(ISNUMBER(SEARCH("200", D2:D8))),C2:C8)
    on D14 = =SUMPRODUCT(--(ISNUMBER(SEARCH("205", D2:D8))),C2:C8)
    on D15 = =SUMPRODUCT(--(ISNUMBER(SEARCH("215", D2:D8))),C2:C8)
    Corine
    Reply With QuoteRegister To Reply
  2. 11-13-2007, 10:12 AM #2
    reborn64
    reborn64 is offline
    Registered User
    Join Date
    11-13-2007
    Posts
    5

    Lightbulb Wow

    Thanks guys, both the answers will work perefectly for me. I'm amazed by how quick that was.

    Again, thanks alot.
    Reply With QuoteRegister To Reply
  3. 11-13-2007, 11:41 AM #3
    EdMac
    EdMac is offline
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Great,

    Thanks for the feedback

    Ed
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1