View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IJQ IJQ is offline
external usenet poster
 
Posts: 2
Default How to Sum cells in a variable raw using VBA?

Summing Cells in a Variable Raw
I am trying to Sum up cell contents in a variable raw, meaning cells in
column N are to be added, but the no of raws may vary. I want to specify Two
conditions to Sum these cells , for example if cell D10="", then Sum all
cells between N4 and N9, assuming that cells N1 up to N3 have already been
Summed up by the macro, otherwise the cell value in N10 is the Product of
L10*M10.
Any Suggestions, Please.