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

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

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

Hi,

Sumproduct lends itself better to additional conditions

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

Mike

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

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