Hi Doc,

I recommend reading Chip Pearsons pages about formulas.
http://www.cpearson.com/excel/MainPage.aspx

(search formula) and you will find lot of examples on how to use conditions
in formulas.

Wkr,

JP


"Doc Behr" <Doc wrote in message
...
Here's an example of a spread sheet:

A B
1 1 $55.25
2 $997.00
3 $693.36
4 1 $535.00
5 1 $325.12
6 $636.36
7 1 $1009.00


can someone help me with an function to help me add up the total of
coloumn
B only if coloumn A has a "1"

I tried this: =SUMPRODUCT(--(Sheet1!A1:A7="1"),Sheet1!B1:B7)
and it wasn't working, i think this is close though