Can I look up 2 criteria? One by typing in the word in inverted columns from a specific column on another sheet e.g. "Superannuation" AND another a cell reference in the existing sheet. How do I specify both in my criteria part of the formula? I have tried using & but it is not returning the correct sum - it gives me zero as I suppose it doesn't know what to look for? My formula looks something like this now =SUMIF(Range,A9&"Superannuation",Sum_Range) - but as I say it is not working.