using SUMIF / SUMIFS
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?
Answers
-
Have you tried...
=SUM([First Column]@row:[Last Column]@row)
-
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
-
I didn't realize you were working on another sheet. My apologies.