Average using Checked Boxes

Hello All,

i am doing a personal project for my company and got stuck with the Average Formula.

i have an excel sheet with 6 Check boxes for 6 Months these check boxes are linked to a particular cell which returns values of TRUE & FALSE and if TRUE particular formula will be executed.

now the issue is i have a cumulative table in the same sheet where it will display the Total Cost along with Average cost per month.

The cumulative table has 4 rows showing the result and the 5th row has Average which gives average of the above costs.

Now, if i select Jan, Feb & March using the checkboxes the average function should add the total values in cumulative table and give me result by dividing the sum/3 since its only 3 months likewise if i select 4 months it should divide by 4 but it is dividing by 4 irrespective of the checkboxes

i have tried =AverageIF(C61:C66,TRUE,C38:C41) - where C61:C66 is checkboxes and C38:C41 is the cumulative values

please help

Thanks

Please post a sample Excel file. including manual calculations showing expected results

To upload, click "Go Advanced" then "Manage Attachments"

any chance you can upload your worksheet?

Hi,

Please see attached Test File

Appreciate your help

thanks

Hi mehmetcik

that didnt work as i dont have any values in D61:D66

Wow That Worked for me Dosydos

You are a real Star

Thanks for helping me out

glad I could help.
please mark this thread as SOLVED by going to thread tools at the top.