Creating Countifs and Averageif Functions in VBA

[bowmanbowman]

[FONT=&quot]I need help creating a few VBA functions in Excel:[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]First I need to write a function (myCountIfs) that works similar to Excel's in built COUNTIFS function. It returns an integer.[/FONT]

1. The first is a range that will be used in the calculation (i.e., average)
2. The first is the 1st range that will be used for the criteria
3. The second is the string value that the criteria cell values must be
4. The third is the 2nd range that will be used for the criteria
5. The fourth is a string value that the criteria cell values must be.
6. For instance, if the user enters myCountIfs(B2:B10,"student", D2:D10, "boat"), the result should return 2.

[FONT=&quot]
[/FONT]
[FONT=&quot]Then I need to write a function (myAverageIf) that works similar to Excel's in-built AVERAGEIF function works. The function should take in three arguments. It returns a double[/FONT]

1. The first is a range that will be used in the calculation (i.e., average)
2. The second is the range that will be used for the criteria
3. The third is a string value that the criteria cell values must be
4. ​For instance, if the user enters myAverageIf(C2:C10, D2:D10, "boat") the resultshould return 1.395.