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.
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives