Column A Column B Column C
100 100 =Sum(A1+B1)/2
100 =Sum(A1+B1)/2
100 100 =Sum(A1+B1)/2
As above i've two columns both with numbers in - i need to add them together and then divide by 2 - however column a and column b may not have a number in so results for above with my formula would be:
C1 100
C2 50
C3 100
and I want them to show:
C1 100
C2 100
C3 100
Thanks.
Hello littlefoot,
Try this:
=IF(COUNT(A1:B1)=2,SUM(A1:B1)/2,SUM(A1:B1))
Let me know if this works!
Steve
A VBA novice, excited to learn!
Instead of using SUM, use the AVERAGE formula. Hence...
and so on!
Please Login or Register to view this content.
Show your appreciation - Press the star icon if this post has been helpful
Mark the thread solved if your problem has been resolved
A much simpler answer than mine Ace!
Great thanks very much never thought of using Average
Cheers. x
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks