Need some help with this Excel formula [Archive] - SpeedGuide.net Broadband Community
PDA

View Full Version : Need some help with this Excel formula

loop2kil
12-12-06, 09:06 PM
=KCY!(E5+E7)/((E5+E7)+COUNTA(A13:A21))

probably overlooking something simple but, it keeps telling me there is an error...I cant seem to find it.

All cells are properly referenced and the tab is correct.
loop2kil
12-13-06, 01:33 AM
never mind...got it

=(KCY!E5+KCY!E7)/((KCY!E5+KCY!E7)+COUNTA(KCY!A13:A21))