Results 1 to 6 of 6

=SUM(SUMIFS()) with multiple criteria

Threaded View

Carlo1994 =SUM(SUMIFS()) with multiple... 04-02-2020, 10:00 AM
Sam Capricci Re: =SUM(SUMIFS()) with... 04-02-2020, 10:11 AM
Carlo1994 Re: =SUM(SUMIFS()) with... 04-02-2020, 10:21 AM
XOR LX Re: =SUM(SUMIFS()) with... 04-02-2020, 10:40 AM
Carlo1994 Re: =SUM(SUMIFS()) with... 04-02-2020, 11:33 AM
XOR LX Re: =SUM(SUMIFS()) with... 04-02-2020, 11:43 AM
  1. 04-02-2020, 10:00 AM #1
    Carlo1994 is offline
    Registered User
    Join Date
    04-02-2020
    Location
    Netherlands
    MS-Off Ver
    Office16
    Posts
    3

    =SUM(SUMIFS()) with multiple criteria

    Hi Everyone,

    I'm hoping someone can help me out.

    What I'm trying to accomplish is that when a cell in the data column contains either "A", "B" or both, the sum gets incremented with 1. Right now it increments with 2. The desired output in cell D2 would be 3 in this case.

    Unfortunately I'm not that experienced with Excel and I'm not able to figure this out

    excelsnippet.PNG

    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. multiple criteria in sumifs - sum(sumifs({}...)) not working without ctrl+shift+enter
    By bgru in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-22-2017, 03:49 PM
  2. A sumifs forumla with multiple criteria in the criteria range
    By bellablu in forum Excel General
    Replies: 3
    Last Post: 02-02-2017, 04:32 AM
  3. [SOLVED] SUMIFS with multiple criteria WITH specified dynamic range criteria
    By dluhut in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2017, 11:03 AM
  4. Sumifs with multiple criteria and criteria in same column
    By Kathryn012 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2017, 07:48 AM
  5. How to sum SUMIFS - multiple criteria for one criteria range???
    By trstew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2016, 02:37 PM
  6. SUMIFS with 1 criteria range, multiple criteria with cell references
    By heatherromo in forum Excel General
    Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  7. Excel 2007 : Sumifs formula lookup multiple criteria in criteria range
    By matthews311 in forum Excel General
    Replies: 1
    Last Post: 05-16-2011, 05:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1