Results 1 to 5 of 5

SUMIF not calculating to required range

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    Diss, Norfolk, England
    MS-Off Ver
    Microsoft 365 Excel
    Posts
    57

    SUMIF not calculating to required range

    Not sure where I'm going wrong but perhaps someone could please educate me (already tried all other avenues first) and it is frustrating me.
    Column A (rows 1 to 15) has values of either "WSH", "COL" or "IPS", whereas my range in D1 to I15 contains numeric (decimal) values. I want to add all values in a row where criteria in Column A meets "WSH", so I applied the formula in cell A17 as: =Sumif(A1:A15,"WSH",D1:I15). It seems to work but only applies the function in range D1 to D15 (totally omitting C1 to I15). See attached example, I use MS-Excel 2016. I welcome your helpful advice (feel foolish posting this).
    Attached Files Attached Files
    Last edited by Kausch; 07-22-2019 at 03:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif Function to work similarly to Sumif Function
    By JMC1927 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2019, 04:10 PM
  2. [SOLVED] How to nest a left function within a sumif function?
    By LisaK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2017, 09:21 AM
  3. Replies: 2
    Last Post: 06-21-2017, 06:32 PM
  4. Replies: 4
    Last Post: 10-08-2013, 05:10 PM
  5. Sumif function using indirect function and data from different sheet
    By pronky007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2013, 12:40 PM
  6. [SOLVED] SUMIF Function Inside SUMPRODUCT Function
    By Abdul Waheed in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-19-2005, 12:05 PM
  7. Replies: 2
    Last Post: 01-11-2005, 07:06 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