Craig_Moore
Board Regular
- Joined
- Dec 12, 2018
- Messages
- 64
- Office Version
- 2019
- Platform
- Windows
Hi All,
i am using the formula below to give me the average production tonnes but i need to ignore the zeros is the a way for me to add this in to my current calculation?
=IFERROR(AVERAGEIFS(L3_TONNES,DATE,">="&AG23,DATE,"<="&EOMONTH(AG23,0)),"0")
Thanks
Craig
i am using the formula below to give me the average production tonnes but i need to ignore the zeros is the a way for me to add this in to my current calculation?
=IFERROR(AVERAGEIFS(L3_TONNES,DATE,">="&AG23,DATE,"<="&EOMONTH(AG23,0)),"0")
Thanks
Craig