Help in EXCEL functions - needed badly

K

kosageinusha18

Hi just a noob here,

I would like to know how or what function do I need to use on this kind of
problem. I am creating a template where the 2nd column B3:B50 has a drop down
option, so I'd like that Column to be counted examples on the drop down are .
NET - TNBA Callbacks and NRA - Montreal EMT.

Ex. if B2:B50 have (10) . NET - TNBA Callbacks it will appear (10) on J15
and if NRA - Montreal EMT have (3) it must appear (3) on J16.

hope that helps in explaining...its too hard to explain, I am wishing if I
could attach the file for better view..

thanks again.. waiting for your response
 
E

Eduardo

Hi,
in J15 enter

=countif(B2:B50,"NET - TNBA")

in J16 enter

=countif(B2:B50,"NRA - Montreal EMT")
 
K

kosageinusha18

Thank you for the quick reply's I will do this right away and will test.. let
me see if it'll work...

thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top