updating information into a macro

[msofficehelp11]

Hi everyone,
I am kind of new to using MSExcel and I am having a little trouble with macros.I have to sum up few rows based on some conditions, so I used a SUMIFS and then I have to count the rows based on some conditions again and so I used a COUNTIFS. I recorded a macro while putting in these formulas.The problem is, if I add more rows to the excel sheet and then run the macro, the new rows will not be included in the computations performed by the macro. Is there a way that this can be resolved?I've done some research on this and all I found was that editing macros is not a good idea. Any inputs would help me greatly. Thanks in advance.

 

[mintjulep]

Named ranges.

 

[SkipVought]

faq68-1331.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}