What If, Count - totally confused......

[LancsGirl]

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

 

[Mike H]

Hi,

This

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

or this

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

Mike

 

[LancsGirl]

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]

Hi,

Sumproduct lends itself better to additional conditions

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

Mike

 

[Shane Devenshire]

Hi,

Try this:

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