Prev: VLOOKUP IS ERROR
Next: Site for some reason, and forbidden
From: Nadine on 6 May 2010 17:00
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




From: Gary''s Student on 6 May 2010 17:08
=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
>
>
>
>
 | 
Pages: 1
Prev: VLOOKUP IS ERROR
Next: Site for some reason, and forbidden