Hi,

Try this:

=SUMPRODUCT((A:A="Y")*(H:H="M")*(J:J))


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"LancsGirl" wrote:

Hi Mike,
Thanks for that - worked a treat :-)

Can I add another if in there too? The list contains unique identifiers for
practices and then the staff are held against each one so I want to say if
practice is 'Y'(column A) and sex is 'M' (Column H) then calculate result of
what is in Column J.
I've inherited this spreadsheet!
Thanks


"Mike H" wrote:

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