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

Pretty close! Just remove the quotes from around 1:

=SUMPRODUCT(--(Sheet1!A1:A7=1),Sheet1!B1:B7)

Here's a couple of alternatives...

If column A contains only the number 1 or blank/empty cells:

=SUMPRODUCT(Sheet1!A1:A7,Sheet1!B1:B7)

This is the best option:

=SUMIF(Sheet1!A1:A7,1,Sheet1!B1:B7)

--
Biff
Microsoft Excel MVP


"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