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 ERRORNext: Site for some reason, and forbidden