worksheetfunction countifs, counting down and across, application defined error

Hi there,

I am trying to come up with a VB solution that counts records based on conditions in VB. I have attached the file.

In "Quarterly reports ALL" sheet, you see a table and ONLY B3 to Q19 need values to be populated by VB.

The "IC collection" is where data gets collected.

The following code is countifs using VB, but it's not quite working.

n is the row counter on the report page while r is the column counter on the report page.

Please Login or Register  to view this content.

When I run the code, I get the application-defined error. I must have got the range target wrong or some sort of syntax error, but I'm not sure.

Anyone able to assist?

Thanks

Yes, I am counting the total number of records in the IC data collection based on conditions specified in the quarterly reports ALL worksheet. The "Quarter Reports ALL" worksheet is just a report template that's used to populate numbers.

An example would be...if you go to "Quarterly reports ALL", B4 would be the total number of counts for AAA and Upper Respiratory that has been collected in the "IC data collection". C4 is the total number of records collected for BBB and Upper Respiratory, B9 would be the total number of records collected for AAA and GI, etc.

I thought I would use two loops, one for the row down and the other for the column across, but it's not working at this stage.

Is anyone able to assist?

Thanks

What does the AAA, BBB etc do, I don't follow? Could you place some data as to how you want it represented in both sheets?