formula help!!

M

Mike Kasiorek

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
 
J

JulieD

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
 
P

Paul Falla

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
 
Top