how to minus a zero when using average
- Thread starter shaggy72
- Start date
lohithsriram
Active Member
Hi ,
Is that with VBA or the Excel function your are trying with. Do you have any sample for this?
Is that with VBA or the Excel function your are trying with. Do you have any sample for this?
NARAYANK991
Excel Ninja
Hi ,
If you have Excel 2010 and later , you can use the AVERAGEIF function , otherwise , you can simulate its behaviour by using a combination of AVERAGE and IF , entering it as an array formula , using CTRL SHIFT ENTER.
This is described here :
http://stackoverflow.com/questions/5325503/excel-average-if
Read all the answers , especially the one which points out possible error results.
Narayan
If you have Excel 2010 and later , you can use the AVERAGEIF function , otherwise , you can simulate its behaviour by using a combination of AVERAGE and IF , entering it as an array formula , using CTRL SHIFT ENTER.
This is described here :
http://stackoverflow.com/questions/5325503/excel-average-if
Read all the answers , especially the one which points out possible error results.
Narayan
Did you try searching here?
Every page has a Search Box on it
You would have found :
http://chandoo.org/forum/threads/using-iferror-and-average-need-help.11639/#post-68217
Every page has a Search Box on it
You would have found :
http://chandoo.org/forum/threads/using-iferror-and-average-need-help.11639/#post-68217