Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Formula?
For example worksheet 1 Column A B C D & E have multiple
Numbers ranging from 2001, 2010, 2017, 2025, 2027, 2036 & 2038. Worksheet 2, 3 & 4 Have the same. What i want to acheive is something to look at each column in each worksheet and count, how many times each number appears and bring back a result for each in a different worksheet. |
#2
|
|||
|
|||
=COUNTIF('Sheet1'!$A$2:$A$200,2001)
=COUNTIF('Sheet2'!$A$2:$A$200,2001) and so on if you put the list of numbers in the summary sheet then just copy down (assume they are in A2:A6 =COUNTIF('Sheet1'!$A$2:$A$200,A2) Regards, Peo Sjoblom "Mark" wrote: For example worksheet 1 Column A B C D & E have multiple Numbers ranging from 2001, 2010, 2017, 2025, 2027, 2036 & 2038. Worksheet 2, 3 & 4 Have the same. What i want to acheive is something to look at each column in each worksheet and count, how many times each number appears and bring back a result for each in a different worksheet. |
#3
|
|||
|
|||
thanks this works great
-----Original Message----- =COUNTIF('Sheet1'!$A$2:$A$200,2001) =COUNTIF('Sheet2'!$A$2:$A$200,2001) and so on if you put the list of numbers in the summary sheet then just copy down (assume they are in A2:A6 =COUNTIF('Sheet1'!$A$2:$A$200,A2) Regards, Peo Sjoblom "Mark" wrote: For example worksheet 1 Column A B C D & E have multiple Numbers ranging from 2001, 2010, 2017, 2025, 2027, 2036 & 2038. Worksheet 2, 3 & 4 Have the same. What i want to acheive is something to look at each column in each worksheet and count, how many times each number appears and bring back a result for each in a different worksheet. . |
#4
|
|||
|
|||
Also keep in mind some other great things this function does:
=COUNTIF(Range,Criteria) =COUNTIF(A2:B:20,"=1000") "all the cells that have a value greater than or equal to 1000 Good Luck " wrote: thanks this works great -----Original Message----- =COUNTIF('Sheet1'!$A$2:$A$200,2001) =COUNTIF('Sheet2'!$A$2:$A$200,2001) and so on if you put the list of numbers in the summary sheet then just copy down (assume they are in A2:A6 =COUNTIF('Sheet1'!$A$2:$A$200,A2) Regards, Peo Sjoblom "Mark" wrote: For example worksheet 1 Column A B C D & E have multiple Numbers ranging from 2001, 2010, 2017, 2025, 2027, 2036 & 2038. Worksheet 2, 3 & 4 Have the same. What i want to acheive is something to look at each column in each worksheet and count, how many times each number appears and bring back a result for each in a different worksheet. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot change a formula | Excel Discussion (Misc queries) | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Formula displays does not calculate | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) |