I need my macro to ignore empty cells when averaging and not use them as a 0 thus giving me the incorrect answer.
Please Login or Register to view this content.
I need my macro to ignore empty cells when averaging and not use them as a 0 thus giving me the incorrect answer.
Please Login or Register to view this content.
How are you calling the function?
Entia non sunt multiplicanda sine necessitate
=dailymeanload
Is that what you meant? my apologises for my lack of understanding the Q...
Is it entered in a cell? If so, what is the formula?
yes it is entered in a cell as:
=dailymeanload(council,workout1,workout2,workout3,workout4,workout5)
the problem is that there may only be 3 out of the 5 cells with numbers in them and it includes the blanks as empty.
Please Login or Register to view this content.
You're a genius shg - hope you have a great day!!!
Any chance you know how to substitute the average for a stdefv.s?
Thats what I have and it's not working...Please Login or Register to view this content.
I've just subbed average out for stdeva/ stdeva.s and it doesn't work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks