Formula for a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I create into an excell spreadsheet every week. I have written formulas for this weekly report, and my problem is typing the formulas in every week. Is there a way to either import my formula into my report or vice versa, import my report to my formulas. Also, one more thing. The formula counts the total number of rows that have data and I have to type in the range everytime. Is there a way to use a variable that automatically finds out the range? Thanks in advance for your help, I know it can be done, I just don't know how.

Ian
 
Hi Ian

not quite sure how you import your report in Excel but normally you can
easily copy your formulas or use a predefined template, etc.. So maybe
you can provide some example data (plain text, not attachments please)

For your second question:
One way (if you have no blank rows in between you may use COUNTA):
=COUNTA(range)
or
=SUM(OFFSET($A$1,0,0,COUNTA($A:$A)))
 
Here is some example data, and I will try and do a better job explaining. Here is the Dat

Date Call Type Specialty Nam
2/20/04 Detail FP Adam
2/10/04 Detail CD Patc

There are my headers for the report, Here is my problem....Every week I generate this report to excel, every week there is a different number of entries. For instance, Week One I will have 45 Entries next week I will have 22. That is why I was wondering about the formula because the range changes every week. Plus, I have about 8 Formulas I have to type in every week so that is why I wanted find a way to calculate my formulas w/o typing them in every week. Can you explain how to do a template for instance that counts the total number of Entries or in my instance calls? Thank you for your help

Ian
 
Hi
where do you put your formulas? On the same sheet just below the
imported data. If yes you may consider the following:
1. Put your formulas at the top of your spreadsheet and import your
data below or put your formulas on a spearate (Summary) sheet
2. Nor problem to count the numbers of entries.
e.g.
=COUNTA(A1:A100)-1 (-1 for the heading row)
to count the number of entries

or
=SUMPRODUCT((B1:B100="Detail")*(C1:C100="FP"))
to count specific call types
 
Back
Top