formula help!!

Hello there, I am desperate for some help on a excel project....basicaly
I have 2 columns, one will be a "Y" and the other a "N"...I need to come
up with a formula to add these up at the end of the column...I don't
know how to write a formula that tells it that, for example Y=1 and then
add columns C3 to C175..I would really appreciate it if some kind soul
could help me out...thanks, Mike

Hi Mike

i think you're after the SUMIF function

=SUMIF(A3:A175,1,C3:C175)
will add up the values in C3:C175, where the corresponding cell in column A
has a 1 in it

or
=SUMIF(A3:A175,"Y",C3:C175)
will add up the values in C3:C175, where the corresponding cell in column A
has a Y in it

Hope this helps
Cheers
JulieD

"Mike Kasiorek" wrote in message
...
Hello there, I am desperate for some help on a excel project....basicaly
I have 2 columns, one will be a "Y" and the other a "N"...I need to come
up with a formula to add these up at the end of the column...I don't
know how to write a formula that tells it that, for example Y=1 and then
add columns C3 to C175..I would really appreciate it if some kind soul
could help me out...thanks, Mike

Dear Mike

It sounds like you need to count the number of "y"s
and "n"s in the two columns. This is easily achieved by
entering =Counta(A3:A175) in the cell directly below the
last cell containing "y" (assuming the "y"s are in column
A. Copy and paste the formula in the cell directly below
the last "n" value to count the number of "n"s. This way
you don't have to worry about assigning a numerical value
to to the letters

Hope this helps

Paul Falla
-----Original Message-----
Hi Mike

i think you're after the SUMIF function

=SUMIF(A3:A175,1,C3:C175)
will add up the values in C3:C175, where the
corresponding cell in column A
has a 1 in it

or
=SUMIF(A3:A175,"Y",C3:C175)
will add up the values in C3:C175, where the
corresponding cell in column A
has a Y in it

Hope this helps
Cheers
JulieD

"Mike Kasiorek" wrote in message
...
Hello there, I am desperate for some help on a excel
project....basicaly
I have 2 columns, one will be a "Y" and the other
a "N"...I need to come
up with a formula to add these up at the end of the
column...I don't
know how to write a formula that tells it that, for
example Y=1 and then
add columns C3 to C175..I would really appreciate it if
some kind soul
could help me out...thanks, Mike



.