I have a worksheet with the following data which are all results of formulas
in each cell. On another worksheet, I need to sum all the amounts in Col C
if Col A=1 AND Col B=No. Can anyone helpwith this in Excel 2003? Thanks.

Here's some of my data:
No No $-
1 Yes $7,011.08
1 Yes $1,017.77
No No $-
1 Yes $23,205.00
1 Yes $68,300.82
1 Yes $24,477.37
1 Yes $7,023.52
1 Yes $739.25
1 Yes $16,977.94
No No $-
1 Yes $14,056.64
1 Yes $6,949.76
1 No $8,890.43
No No $17,287.55
1 No $776.36
1 Yes $18,512.61
1 No $21,168.08
1 Yes $5,335.93
1 No $28,880.00
1 No $54,493.77
1 Yes $5,362.08
1 No $41,173.60
1 No $-
1 Yes $18,390.56
No No $14,952.88
1 Yes $14,886.16
1 Yes $37,225.00
1 No $8,676.44
1 Yes $10,824.89

=SUMPRODUCT((A2:A101=1)*(B2:B101="No"),(C2:C101))

--
Gary''s Student - gsnu201002


"Nadine" wrote:

I have a worksheet with the following data which are all results of formulas
in each cell. On another worksheet, I need to sum all the amounts in Col C
if Col A=1 AND Col B=No. Can anyone helpwith this in Excel 2003? Thanks.

Here's some of my data:
No No $-
1 Yes $7,011.08
1 Yes $1,017.77
No No $-
1 Yes $23,205.00
1 Yes $68,300.82
1 Yes $24,477.37
1 Yes $7,023.52
1 Yes $739.25
1 Yes $16,977.94
No No $-
1 Yes $14,056.64
1 Yes $6,949.76
1 No $8,890.43
No No $17,287.55
1 No $776.36
1 Yes $18,512.61
1 No $21,168.08
1 Yes $5,335.93
1 No $28,880.00
1 No $54,493.77
1 Yes $5,362.08
1 No $41,173.60
1 No $-
1 Yes $18,390.56
No No $14,952.88
1 Yes $14,886.16
1 Yes $37,225.00
1 No $8,676.44
1 Yes $10,824.89