MamaStacia
New Member
- Joined
- Jul 29, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Hello, Thank you for your help. I have a formula that works fine as long as there are not any errors in the cells it's calculating. If there are any errors it returns a #N/A error. I am trying to find the average of 2 columns monthly without averaging averages (which would be incorrect data). The only thing that is different in the 2 formulas below is I added +(D14/D14) and D14 & E14 have a vlookup #N/A error since it's for Aug which doesn't have data yet. Is there an IFERROR, IFNA, or SUMIF function I can use with the formula below so I can set it and forget it for 12 months of data? The formula I tried wouldn't work.
Working Formula
=((D8/E8)+(D9/E9)+(D10/E10)+(D11/E11)+(D12/E12)+(D13/E13))/(COUNT(C8:C18)) = 59.1%
Error Formula
=((D8/E8)+(D9/E9)+(D10/E10)+(D11/E11)+(D12/E12)+(D13/E13)+(D14/E14))/(COUNT(C8:C18)) = #N/A
Tried Formula
=SUMIF(((D8/E8)+(D9/E9)+(D10/E10)+(D11/E11)+(D12/E12)+(D13/E13)+(D14/E14))/(COUNT(C8:C18)),">=0")
Working Formula
=((D8/E8)+(D9/E9)+(D10/E10)+(D11/E11)+(D12/E12)+(D13/E13))/(COUNT(C8:C18)) = 59.1%
Error Formula
=((D8/E8)+(D9/E9)+(D10/E10)+(D11/E11)+(D12/E12)+(D13/E13)+(D14/E14))/(COUNT(C8:C18)) = #N/A
Tried Formula
=SUMIF(((D8/E8)+(D9/E9)+(D10/E10)+(D11/E11)+(D12/E12)+(D13/E13)+(D14/E14))/(COUNT(C8:C18)),">=0")