LinkBack URL
About LinkBacks
I have a column of dollar amounts (variances) and next to each is the shift they belong to.
I am looking to get a break down of the variances for each shift.
Attached is an example of what it looks like.
thanks for any help with this formula.
Nick
I have a column of dollar amounts (variances) and next to each is the shift they belong to.
I am looking to get a break down of the variances for each shift.
Attached is an example of what it looks like.
thanks for any help with this formula.
Nick
Last edited by avidcat; 01-15-2010 at 04:38 PM.
In B4, copied down: =SUMIF($B$13:$B$26,$A4,$D$13:$D$26)
In C4, copied down: =COUNTIF($B$13:$B$26,$A4)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Very cool, thanks Palmetto.
I have the Net total and number of variances working now, do you know how to get my other column to add the absolute (ABS) totals for each?
thanks,
Nick
For Excel 2007:
=SUMIFS($D$13:$D$26,$B$13:$B$26,A4,$D$13:$D$26,">0")+ABS(SUMIFS($D$13:$D$26,$B$13:$B$26,A4,$D$13:$D$26,"<0"))
Pre-2007
=SUMPRODUCT(--($B$13:$B$26=A4),--($D$13:$D$26>0),($D$13:$D$26))+ABS(SUMPRODUCT(--($B$13:$B$26=A4),--($D$13:$D$26<0),($D$13:$D$26)))
Thanks, worked perfect.
Nick
Assuming A4:A6 just contains "Day", "Swing" or "Grave" then you can use this formula for the ABS value
=SUMPRODUCT(($B$13:$B$26=A4)*ABS(D$13:D$26))
Thanks daddylonglegs.
I'm a little slow to join this party, but both the question and the responses have proven very helpful to me this morning!
Thanks!
-julia
what if i have multiple columns? see attached
need to add data from b2:b12,d2:d12,f2:12,h2:h12 and show totals in L2:L7
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks