LinkBack URL
About LinkBacks
Hi,
In the attached file I'm using three sumif equations to select and sum three different numbers in a single column whilst ignoring the other numbers. How can I do this with one formula?
Cheers,
Bill
Hi,
In the attached file I'm using three sumif equations to select and sum three different numbers in a single column whilst ignoring the other numbers. How can I do this with one formula?
Cheers,
Bill
A simple way is like this:
=SUMIF(B$1:B$9,D9,A$1:A$9) + SUMIF(B$1:B$9,E9,A$1:A$9) + SUMIF(B$1:B$9,F9,A$1:A$9)
Hope this helps.
Pete
Thanks Pete, that works fine.
Bill
=sum(index((((b1:b9=d9)+(b1:b9=e9)+(b1:b9=f9))>0)*(a1:a9),0))
try this
and freeze the column ranges as you need ..Originally Posted by nflsales
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Try this......
=SUMPRODUCT((B1:B9=D9:F9)*A1:A9)
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks