counta formula

[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

 

[JE McGimpsey]

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".

 

[Andy B]

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.

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

 

[Guest]

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

i am trying to count a range of cells that have different names.how can

use counta to only sum one if the names in the rang of chosen cells? thx wy