Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
I have several drop down menus on sheet 1 with employee names in column H
is there a formula I can use in sheet 2 that will only count individuals -- for example =countif(H1:H100,"=John Doe") but draw the information from sheet 1 -- grizz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
On sheet2, use a formula like this perhaps:
=COUNTIF(Sheet1!H1:H100,"John Doe") -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "grizzly6969" wrote: I have several drop down menus on sheet 1 with employee names in column H is there a formula I can use in sheet 2 that will only count individuals -- for example =countif(H1:H100,"=John Doe") but draw the information from sheet 1 -- grizz |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
I thought that would be the correct formula but it will not work. Does it
make a differance if all the names are selected from a drop down menu -- grizz "JBeaucaire" wrote: On sheet2, use a formula like this perhaps: =COUNTIF(Sheet1!H1:H100,"John Doe") -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "grizzly6969" wrote: I have several drop down menus on sheet 1 with employee names in column H is there a formula I can use in sheet 2 that will only count individuals -- for example =countif(H1:H100,"=John Doe") but draw the information from sheet 1 -- grizz |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
No. The problem is most likely with the data. In a cell near one of your
"drop down" John Doe cells, enter the same name manually. Now compare them with a simple formula: =A1=B1 If they are completely identical, you will see TRUE. Frequently, people make mistakes creating drop down lists and have trailing spaces in there that are invisible. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "grizzly6969" wrote: I thought that would be the correct formula but it will not work. Does it make a differance if all the names are selected from a drop down menu -- grizz "JBeaucaire" wrote: On sheet2, use a formula like this perhaps: =COUNTIF(Sheet1!H1:H100,"John Doe") -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "grizzly6969" wrote: I have several drop down menus on sheet 1 with employee names in column H is there a formula I can use in sheet 2 that will only count individuals -- for example =countif(H1:H100,"=John Doe") but draw the information from sheet 1 -- grizz |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
Yes I got the TRUE response soooo is there a way I can correct the problem
with the drop down -- grizz "JBeaucaire" wrote: No. The problem is most likely with the data. In a cell near one of your "drop down" John Doe cells, enter the same name manually. Now compare them with a simple formula: =A1=B1 If they are completely identical, you will see TRUE. Frequently, people make mistakes creating drop down lists and have trailing spaces in there that are invisible. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "grizzly6969" wrote: I thought that would be the correct formula but it will not work. Does it make a differance if all the names are selected from a drop down menu -- grizz "JBeaucaire" wrote: On sheet2, use a formula like this perhaps: =COUNTIF(Sheet1!H1:H100,"John Doe") -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "grizzly6969" wrote: I have several drop down menus on sheet 1 with employee names in column H is there a formula I can use in sheet 2 that will only count individuals -- for example =countif(H1:H100,"=John Doe") but draw the information from sheet 1 -- grizz |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
Thanks JB -- I got it to work -- I just noticed sheet 1 name was change a
little and once I put the correct sheet in it worked fine -- again thanks -- grizz "grizzly6969" wrote: I have several drop down menus on sheet 1 with employee names in column H is there a formula I can use in sheet 2 that will only count individuals -- for example =countif(H1:H100,"=John Doe") but draw the information from sheet 1 -- grizz |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
using countif on sheet 2
Glad to hear...told you, the formulas are the same, so it's the data layout
that usually is the culprit. Your feedback is appreciated, click YES if this post helped you. "grizzly6969" wrote: Thanks JB -- I got it to work -- I just noticed sheet 1 name was change a little and once I put the correct sheet in it worked fine -- again thanks -- grizz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif within a filtered sheet | New Users to Excel | |||
Countif using the same cell on every sheet | Excel Worksheet Functions | |||
Countif on two columns in a sheet | Excel Discussion (Misc queries) | |||
Using CountIf with criteria on another sheet? | Excel Worksheet Functions | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions |