using SUMIF / SUMIFS

06/30/20
Answered - Pending Review

im now starting to become formula blind, help

i have 1 column with a reference to use as the identifier, "1-3" in the image, but i want to SUM up all the values in multiple columns! But the only way i can get this to work is looking at a single column for the argument rather than using the left column to then SUM up all the data within the range for the multiple columns,,,, any ideas?


Tags:

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Have you tried...

    =SUM([First Column]@row:[Last Column]@row)

    thinkspi.com

  • Cameron McGregorCameron McGregor ✭✭✭✭✭

    i haven't, but without the option to use an array within the SUMIF or IFS, i added a helper to the source, SUMed up all columns individually and then from the main grid pulled the data that way... a long road around..

    =SUMIF({Grid for Azt2 mantechs t&v Range 6}, = 4, {Grid for Azt2 mantechs t&v Range 7}@row:{Grid for Azt2 mantechs t&v Range 8}@row)

    thanks for replying, tried this as you suggested but unparseable

    cameron

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    I didn't realize you were working on another sheet. My apologies.

    thinkspi.com

Sign In or Register to comment.