counta formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to count a range of cells that have different names.how can i use counta to only sum one if the names in the rang of chosen cells? thx wyn
 
I'm not sure what you're asking...

You can sum named ranges directly:

=SUM(myRange)

which will sum all the cells in the named range "myrange".
 
wyn

Have a look at SUMIF(). Try something like:
=SUMIF(A2:A50,"name",B2:B50)
This will look at the rang A2 to A50 and if any of them equal "name" Excel
will sum the relevant cell in B2 to B50. Is this what you are looking for?

Andy.


wyn said:
i am trying to count a range of cells that have different names.how can i
Click to expand...
use counta to only sum one if the names in the rang of chosen cells? thx wyn
 
hi andy b, that works great.thank you.wy

----- Andy B wrote: ----

wy

Have a look at SUMIF(). Try something like
=SUMIF(A2:A50,"name",B2:B50
This will look at the rang A2 to A50 and if any of them equal "name" Exce
will sum the relevant cell in B2 to B50. Is this what you are looking for

Andy


wyn said:
i am trying to count a range of cells that have different names.how can
Click to expand...
use counta to only sum one if the names in the rang of chosen cells? thx wy
 
Back
Top