Results 1 to 9 of 9

Assistance with Simplified SumIf Formula

Threaded View

  1. #1
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Assistance with Simplified SumIf Formula

    Hi All

    I have a formula to calculate a Total. I have attached my workbook.
    Formula is in F8. I need to look up the total sales for all Super 7 products.
    Is there a easier way than the following:

    Formula: copy to clipboard
    =SUM(SUMIF(B8:B844,"*"&"FITCH & LEEDES"&"*",D8:D844)+SUMIF(B8:B844,"*"&"F&L"&"*",D8:D844)+SUMIF(B8:B844,"*"&"MUSGRAVE"&"*",D8:D844)+SUMIF(B8:B844,"*"&"HALLS"&"*",D8:D844)+SUMIF(B8:B844,"*"&"ROSES"&"*",D8:D844)+SUMIF(B8:B844,"*"&"M/FALLS"&"*",D8:D844)+SUMIF(B8:B844,"*"&"NETTARI"&"*",D8:D844)+SUMIF(B8:B844,"*"&"HOPE"&"*",D8:D844)+SUMIF(B8:B844,"*"&"LUCY'S SUMMER GIN"&"*",D8:D844)+SUMIF(B8:B844,"*"&"300ML"&"*",D8:D844)+SUMIF(B8:B844,"*"&"JUICEBOX APPLE FIZZ"&"*",D8:D844))
    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. [SOLVED] Suggest Simplified Formula
    By kundanlal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2016, 06:47 AM
  2. Replies: 0
    Last Post: 02-05-2016, 08:14 AM
  3. [SOLVED] Formula working but need simplified mathematics
    By makinmomb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2014, 11:06 AM
  4. Sumif Formula Assistance need to calculate vacation/illnes hours
    By J_Norris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2013, 03:23 PM
  5. Can Formula Be Simplified?
    By natei6 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2007, 04:56 AM
  6. SUMIF simplified
    By Gunjani in forum Excel General
    Replies: 7
    Last Post: 03-19-2006, 06:09 PM
  7. Formula SUMIF assistance
    By TQB in forum Excel General
    Replies: 5
    Last Post: 01-24-2005, 07:55 PM

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