need formula to count entries on each of 3 sheets?

G

Guest

I need to enter a formula on ONE sheet that'll tally entries on 3 other
sheets. For example, Sheet #4 is what I'll call my master sheet where several
formulas/lookups, etc are entered. Sheet 1 is called Jones, Sheet 2 is called
Ross, Sheet 3 is called Waters. Each sheet has up to let's say 10 lists of
Clients in cell A5 thru A20, for example. I want to be able to enter a
formula on Sheet #4 so that it will automatically count how many items are
listed in the cells on each Sheet and then multiply that number by 120. So,
if Jones has 5 entries, the formula on Sheet 4 will automatically enter 600
in a cell on Jones' sheet; if Ross has 7 entries, that formula will calculate
840. Each time the list is added to or subtracted from, this formula will
calculate that. (I've tried COUNTA, but I know I'm missing the sheet tab info
somehow) thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Sumning of Same Cell from Different Sheets 3
Formula Based on Multiple Sheets 5
Excel Formula - Count Dates from another Sheet 8
difference of 2 cells from 2 sheets to appear on sheet 3? 2
count unique entries across worksheets 6
refer to sequential sheets in a formula 3
Excel formula help please 3
What type of "lookup" 3

Top