Hi,
I have VBA for countif formula :
I need to make it to countifs, cause i have mutiple criteria to count, anyone can help?Function myCountIf(rng As Range, criteria) As Long Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets myCountIf = myCountIf + WorksheetFunction.CountIf(ws.Range(rng.Address), criteria) Next ws End Function
Thanx.
Bookmarks