LinkBack URL
About LinkBacks
Hi,
Use this array formula
=SUM(IF(ISNUMBER(range),range,""))
Hold down CTRL & SHIFT while pressing ENTER to confirm this
Hi,
Use this array formula
=SUM(IF(ISNUMBER(range),range,""))
Hold down CTRL & SHIFT while pressing ENTER to confirm this
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thanks for prompt reply.
what should I give in range
=SUM(IF(ISNUMBER(C5:C16),range,""))
shubhkaran
Same range
=SUM(IF(ISNUMBER(C5:C16),C5:C16,""))
Dave
You could try
=SUMIF(C5:C16,"<>#N/A")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks