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.