Ahh ok! You want to do some counting of column C, but actually look in the
row beneath the matching row. What is unclear now is what you want to
count.. you refer to column Cs content as "text" and have not provided any
criteria on what should be counted. What is in column C and what should be
counted?

Not that I'll neccessarily be able to do it once I know what you want to
count, but it is an important thing to know.




"Sam via OfficeKB.com" wrote in message
...
Hi Dave,

Thanks for reply. Further assistance very much appreciated.

Apologies for my original muddled explanation. I think you're on the right
track but hindered by my lack of info and clarity. I'll try to explain
what I'm trying to achieve.

3 Columns - A, B and C with data. The Data to be counted is text in Column
C.

1) I need to first match two conditions for column A and B - criteria in
F1
and G1
2) When conditions met for columns A and B on say Row 12, Count the data
in
Column C Row 13.

I need the Count to start from the Row Below the matched Criteria Row and
for it to Count the data in Column C and continue matching Criteria in
Columns A and B and Counting through my worksheet range to finally produce
a Summed Count of data in column C.

Example:
ROW 12 Data in Row 12 column A and B matches criteria - Count data for ROW
13 in Column C
ROW 20 Data in Row 20 column A and B matches criteria - Count data for ROW
21 in Column C
ROW 40 Data in Row 40 column A and B matches criteria - Count data for ROW
41 in Column C etc.,

So, when matched Criteria found in columns A and B I need an ongoing
Count
of data for Column C the Next Row(Row Below matched Criteria) until it
gets
to the end of my worksheet range to produce a Summed Count of data found
in
column C (always counting Column C Row below matched Criteria) based on
the
Criteria being previously matched in Columns A and B.

I hope this is clearer.

Any further assistance very much appreciated.

Regards,
Sam

--
Message posted via http://www.officekb.com