Hi,

This

=SUMIF(A1:A30,"x",H1:H30)

or this

=SUMPRODUCT((A1:A30="x")*(H1:H30))

Mike



"LancsGirl" wrote:

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