Newbie VBA question

Hey all. So I have an excel workbook containing two sheets, 'Sheet1' and 'Sheet2'. Sheet1 contains 5 columns (and about 600 rows) of data pulled from a database, and Sheet2 is where I ultimately want to store summaries of that data...here is an explanation of my columns in Sheet1:

A - Create_Time
B - Item
C - Status
D - Assigned_To_Group_
E - Assigned_To_Individual_

Here is an example (via pseudocode) of one thing I want to do in Sheet2:

Please Login or Register  to view this content.

So, for every item in column C (sheet1) that is equal to "Assigned", CountA its respective item in column B (and store the count in Sheet2 in cell A1)

Can anyone please help me with this? If it makes it easier, I don't have to use two sheets but that is my ultimate goal. thanks...

also..

i suppose B:B doesnt have to be counted, counting C:C works too

That works great, thanks!

I was wondering if you could explain it to me though. I can't say I really understand it, and would like to tailor it to perform other functions as well.

Specifically, I don't understand what the following line is doing...

Set rCount = .Range(.Cells(1, 3), .Cells(.Rows.Count, 3).End(xlUp))


Thanks!

I think you will be better served by building a Pivot Table. This will do all of the counting for you without the need to write a single line of code.