Calculate totals with an IF statement

I need to know how to calculate totals from a spreadsheet in conjunction with an IF statement.
I have a columns A & B below, i would like to calculate the numbers in coulmn B only if they match a specific criteria in column A.
For example: I want calculate the total of the numbers in coulmn 'B' only if column A is a '1'.

A B
2 4
3 3
1 2
2 1
3 5
1 3
2 2

I would appreciate any help that could be offered.

Thanks

Hi,

You need an array formula i.e Control Shift Enter instead of Enter

Please Login or Register  to view this content.

HTH
Carim

Glad your problem's fixed.

Thanks for the feedback

Carim

Mark you are right ...
I am getting completely distorted ... !!!

Cheers
Carim

You are right ...
Your solution is far better AND much easier to understand ... !!!

Cheers
Carim

Could i add another column into the query, say another column similar to A that i would want to match up as follows.
If there is a 1 in column A and a 1 in column B, then add the numbers in column C?

Originally Posted by acrookes

Could i add another column into the query, say another column similar to A that i would want to match up as follows.
If there is a 1 in column A and a 1 in column B, then add the numbers in column C?

Try:
=SUMPRODUCT(--(A2:A8=1),--(B2:B8=1),C2:C8)

Sumproduct generally works better if you have more than one condition.

Scott

Yes,

You can add as many columns and criteria as you wish with text or numbers ...

But you will have to move to THE formula ...
Sumproduct()

Why don't you fully analyze your requirements and then post all the deatils of your request ...

HTH
Carim

Thanks for all of the help, and sorry for the late add on.
I am all done now.