Newbie here. Trying to sum a column when the criteria is the difference between two columns. For example, the sum of column A for rows in which (columnB - columnC)>10. Any help?
Newbie here. Trying to sum a column when the criteria is the difference between two columns. For example, the sum of column A for rows in which (columnB - columnC)>10. Any help?
Hello and welcome to the forum,
Suggestion #1 :
Use a helper column with B-C results.
Suggestion #2:
Suggestion #3: (array formula)Please Login or Register to view this content.
Array formula means that you must validate by using CTRL+SHIFT+ENTERPlease Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks