SOLVED

Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2724629%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724629%22%20slang%3D%22en-US%22%3E%3CP%3EI%20put%20this%20formula%20%22SUM(G5%3AG28)%2FCOUNTA(G5%3AG28)%22%20on%20excel%20in%20Macro%20enable%20xlsm%20but%20it%20does%20not%20provide%20the%20correct%20answer.%20However%20if%20I%20put%20the%20same%20formula%20into%20new%20sheet%20and%20it%20works.%20I%20can%20not%20find%20the%20problem%20in%20my%20current%20sheet.%20Anyone%20help%20me%20to%20get%20the%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2724629%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2724651%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724651%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1147867%22%20target%3D%22_blank%22%3E%40aliulazim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20about%20instead%20you%20use%20the%20following%20formula%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DAVERAGE(G5%3AG28)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2724690%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724690%22%20slang%3D%22en-US%22%3EYes%2C%20I%20can%20use%20this%20formula%20and%20it%20works%20on%20my%20sheet.%20Thank%20you%20Juliano-Petrukio.%3C%2FLINGO-BODY%3E
New Contributor

I put this formula "SUM(G5:G28)/COUNTA(G5:G28)" on excel in Macro enable xlsm but it does not provide the correct answer. However if I put the same formula into new sheet and it works. I can not find the problem in my current sheet. Anyone help me to get the solution?

3 Replies

@aliulazim 

What about instead you use the following formula:

=AVERAGE(G5:G28)

 

Yes, I can use this formula and it works on my sheet. Thank you Juliano-Petrukio.
best response confirmed by aliulazim (New Contributor)
Solution

Anytime.
I just ask you Please flag it as solved.