Hello,
I have been struggling with this for awhile so figured I would give this forum a chance. I have a large set of data which I need to apply a SUMIFS(). One of the criteria is belonging to a specific account, but there is not a column of that value. There is an example of what I mean attached. The blue column is what I need. Like I said, this is extensive data so manually entering is not an option.
try this in F7 and drag it down as far as you need.
This will work as long as your data structure is similar to the sample shown.HTML Code:
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
There seems to be a contradiction. What is in the blue area appear to be Account: ... numbers (?) and not sums.I have a large set of data which I need to apply a SUMIFS(). One of the criteria is belonging to a specific account, but there is not a column of that value. There is an example of what I mean attached. The blue column is what I need.
This returns what you show in the blue area. In F4 and filled downFormula:
Please Login or Register to view this content.
Dave
Hey there, I only do this once a month so apologies on not getting back to you sooner. This worked perfectly for me. Thank you for the formula!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks