tatendatiffany
Board Regular
- Joined
- Mar 27, 2011
- Messages
- 103
Hie,
i am trying to do a sum if product macro of 5 tables can someone help me because it seem to give me a type mismatch:
can anyone help me modify this code so it works as a sumproduct
table 1 in sheet15 and displaying the results in index column Y2
i am trying to do a sum if product macro of 5 tables can someone help me because it seem to give me a type mismatch:
Code:
If x > 100 Then x = 100
Sheets("table1").Range("Z22") = Application.WorksheetFunction.CountIf(Range("G5:G" & x), "A")
x = 0can anyone help me modify this code so it works as a sumproduct
table 1 in sheet15 and displaying the results in index column Y2
