Results 1 to 19 of 19

Summing data based on several cell contents

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2007
    Posts
    30

    Summing data based on several cell contents

    Wonder if someone can help with this please. I need a formula to give a combination of IF and I think SUMMIFS to calculate totals based on certain cell criteria. Result to be:

    Cell C21 = Total of C2 to C16 where value in column A = UK and value in Coumn B = Orange
    Cell C22 = Total of C2 to C16 where value in column A = UK and value in Coumn B = Apple
    Cell C23 = Total of C2 to C16 where value in column A = UK and value in Coumn B = Pear

    Cell C25 = Total of C2 to C16 where value in column A = USA and value in Coumn B = Orange
    Cell C26 = Total of C2 to C16 where value in column A = USA and value in Coumn B = Apple
    Cell C27 = Total of C2 to C16 where value in column A = USA and value in Coumn B = Pear

    Any assistance would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tagging rows of data based on cell contents
    By fyfey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2014, 10:05 AM
  2. [SOLVED] Summing multiple values based on cell contents
    By NeoFlex in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2013, 04:52 PM
  3. Rows of data based on cell contents
    By stockgoblin42 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2013, 09:25 PM
  4. Replies: 10
    Last Post: 07-01-2013, 09:35 PM
  5. Replies: 2
    Last Post: 10-12-2010, 09:14 AM

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