VBA code for AverageIfs with multiple criteria

[Faridwahidi]

Hi,

Can anyone help me? how to write code for AverageIfs with multiple criteria

Please Login or Register  to view this content.

[pareshj]

Hi Farid,

Check out the below link and hope this will help:

http://www.excelforum.com/excel-gene...onditions.html


Regards,
Paresh J

[Faridwahidi]

Hi Paresh,

This is sample for number while my requirement is for string.


I am understand we can use Application.WorksheetsFunction.Averageifs(rng, rng, ">=3", rng, "<=5")

while it is imposible to use Application.WorksheetsFunction.Averageifs(rng, rng, "Officer", rng, "Executive")

[pareshj]

Hi Farid,

Check my version of AverageIFS file. It is working fine with string too.

AverageIFS.xlsm


Note: To check your code, I would suggest you to break up your code into fragments. Like, just comment your for loop, hardcode some values and check whether it is giving output.

Regards,
Paresh J

[Faridwahidi]

Hi paresh,

Please look at my request. multiple criteria in the same criteria range.

e.g. your data in column B consist of more 4 categories (North, South,West, East). then, I want to calculate average for North & South

I can't use this,

Please Login or Register  to view this content.

I am a bit confused whether we can use SumProduct in VBA code

[Faridwahidi]

Hi All,

Can anyone help me?

I really confused on how to calculate Average with multiple criteria in the same criteria range in VBA. (The criteria is string not a number)

Application.WorksheetsFunction.AverageIfs seems not applicable for string criteria.