Link to home
Start Free TrialLog in
Avatar of gmollineau
gmollineauFlag for Trinidad and Tobago

asked on

Excel AVERAGE with IF

Good Day

I need assistance to in the following:

I have to calculate a weekly average for each month. However the criteria is that the Week Total should only be included in calculating the Weekly Average if the Week Total is >=50% of a supplied Month Weekly Total.

I have attached a sample of the scenario.

Regards

GeraldWeekly_Average_Sample.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial