Hi,

Had a look at numerous posts and the help pages but still cant do this one!

I have a spreadsheet that I want to say
If column A equals 'X' then go to column H and tell me the sum of the
amounts in that column for all the rows where A is equal to the 'X'.

Any help greatly appreciated........ :-)
Ta.
Lesley