I've got two very long columns. The first column has a bunch of different numbers, the second column has an indicator of "1".
My goal is to create a new column that sums the values in column 1 every time the indicator from column 2 is 1.
I created a sample table of what this new column will look like below.
Can someone please help me!
0.1 0 0
0.5 1 0.6
0.9 0 0
0.7 1 1.6
Last edited by vam4pe; 12-03-2015 at 01:26 PM.
Your sample table appears to have disappeared. ;-)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Assuming that you data start (below a header column) in A2 and B2...
=IF(B2=1,SUM($A$2:A2)-SUM($C$1:C1),0)
Paste this into C2 and copy down
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you so much Glenn. That is some good logic!
You're welcome and thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks