Thread: Sum column with errors, Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny Danny is offline
external usenet poster
  
Posts: 148
Default Sum column with errors, Macro
Hi,

I got this great formula from this NG.

=SUMIF(A1:A10,"<"&99^99)

I request for a macro to make the range A1:A10 variable
so it can sum the range where the active cell is.


Thank you.

Reply With QuoteReply With Quote