Hi all,
This is probably simple to many of you, but I need to calculate a SUM of numbers from a spreadsheet ONLY if the column next to the number contains a certain word. However I want to create this formula on a different sheet to the one that contains the numbers.
E.g
House Points
Lion 90
Dragon 62
Lion 86
I need to only SUM the numbers that have lion next to them,
Your help as soon as poss would be much appreciated!
Thank you.
Just realised my spaces didn't work, please see example here:
Capture.PNG
Maybe
=SUMIF(A1:A3,"Lion", B1:B3)
change Lion for other values as required
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Maybe
=SUMIF(A1:A3,"Lion", B1:B3)
change Lion for other values as required
Hi,
Use,You can use any other value in place of Lion..Formula:
Please Login or Register to view this content.
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
Different Approach using Sumproduct function
Formula to be in A3 of Sheet2 =SUMPRODUCT((Sheet1!A3:A5="Lion")*(Sheet1!B3:B5))
Punnam
Thank you, this worked!!Originally Posted by Special-K
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks