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.

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

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.

.

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.

.