Countifs from vbacode

[HarryKlein]

Hi,

I need to put countifs formula from code to a worksheets, but I am stuck with it.

What I need to do is:

iterating through all worksheets , apply a countifs formula and get the result. The searchranges and the criteria_values are changing dinamically therefore I am putting the into variables. My code is something like this.
I need to now how much value fufils the criterias (how much value is on the sheet where myvalue1 in searchrange1=criteria1, and myvalue2 in searchrange2= criteria2)

Would anybody help, how to complete the countifs-function?

Please Login or Register  to view this content.

I need to now how much value fufils the criterias (how much value is on the sheet where myvalue1 in searchrange1=criteria1, and myvalue2 in searchrange2= criteria2)

Would anybody help, how to complete the countifs-function?
many thanks

[bakerman2]

Post an example file with some relevant data in it.
Also include the result you are looking for using the example you provided.