LinkBack URL
About LinkBacks
I am looking for a sum formula that will sum numbers that meet a critera(s) but I would like the sum range to be across multiple colums. Sumifs only has a singular sum range reference. Example attached. Thanks in advanced.
I am looking for a sum formula that will sum numbers that meet a critera(s) but I would like the sum range to be across multiple colums. Sumifs only has a singular sum range reference. Example attached. Thanks in advanced.
Last edited by Dial1; 08-27-2013 at 06:57 PM. Reason: wrong attachment
G11 change to a
G12 change to b
then
I11:
=SUMPRODUCT(($D$4:$D$7=G11)*$E$4:$F$7)
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Thank you Robert, was playing around with sumproduct but could'nt get it working properly. Thank you for the quick learing experience! Cheers!
You are welcome.
Please add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks