I'm trying to perform a VLOOKUP or SUMIF on a range of data in another sheet.
Eg Sheet 1 is where i the formula is.
Sheet 2 has my data on, in the format:-
A B C D E
ValueName 2 4 2 2 2
I can obviously lookup against a single Column, eg B and return the value "4" with the following formula.
However, what i want to do is lookup the sum of A-E to return the value "12"
I'm sure there is a simple way to do it but cant think of it at the moment, so can anyone help?