If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help in EXCEL functions - needed badly
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 |
#2
|
|||
|
|||
Help in EXCEL functions - needed badly
check out the COUNTIF function.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "kosageinusha18" wrote: 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 |
#3
|
|||
|
|||
Help in EXCEL functions - needed badly
Hi,
in J15 enter =countif(B2:B50,"NET - TNBA") in J16 enter =countif(B2:B50,"NRA - Montreal EMT") "kosageinusha18" wrote: 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 |
#4
|
|||
|
|||
Help in EXCEL functions - needed badly
see your other post
-- Biff Microsoft Excel MVP "kosageinusha18" wrote in message ... 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 |
#5
|
|||
|
|||
Help in EXCEL functions - needed badly
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 "Eduardo" wrote: Hi, in J15 enter =countif(B2:B50,"NET - TNBA") in J16 enter =countif(B2:B50,"NRA - Montreal EMT") "kosageinusha18" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|