Hi

Or even better, create a Pivod table based on this consolidated table.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Don Guillett" wrote in message
...
I might put all on ONE sheet starting at row 5
row 5 datenameitem
row 6 1/1/2007 jones bolt
in row1 month number jones bolt
in row 2 =sumproduct((month(a6:a600-1)*(b6:b600=b1)*(c6:c600=c1))
or filter the list and use SUBTOTAL
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SFCWoods" wrote in message
...
Good morning, nothing can ever be easy in the Army. ;-)
I have a workbook with multiple worksheets. The First sheet contains
totals
etc.
I want to be able to count all occurences of data in different tabs and
return those values to specific locations on the first sheet.
Example.
I have SGT Jones, SGT Smith and SGT Adams. Each of these have specific
mission numbers that I need to track for each month.
I want to track,for example, how many times each of them acquires a bolt
and
how many times each acquires a nut for each month.
So I have OCT, NOV, DEC sheets along with the MAIN sheet in the workbook.
On the main Sheet I have each of the Soldiers names in Column A and I
want
to tally the number of bots and nuts for each month in the columns to the
right.
I have tried multiple times to do a countif, but I can't get it to work
right.

I can provide a sample of the workook if necessary. Any help would be
greatly appreciated.