count if

M

MrSpock

Hello, My workbook contains a worksheet for each day of the month for store
sales. What I want to do is count how many times sales are over a certain
amount for a store.
Example my chicago store daily sales are in cell e22 across worksheets 1
through 31, i want to count how many times the stores sales were over say
1000.
Sure would appreciate any help this is driving me crazy. LOL

Roger
 
T

T. Valko

Assuming your sheet names are 1, 2, 3, 4 .... 31

=SUMPRODUCT(COUNTIF(INDIRECT("'"&ROW(INDIRECT("1:31"))&"'!E22"),">1000"))
 
M

MrSpock

Thank You very much for your help. When I paste this into my workbook though
I get a #REF error. The sheet names are as you assume except that sundays are
not there such as 1,2,3,4,5,7,8,9,10,11,12,14 etc.
 
T

T. Valko

In that case I would just use an additional cell (the same cell on each
sheet) with a formula like this:

F22:

=--(E22>1000)

Then on your summary sheet:

=SUM('1:31'!F22)
 
M

MrSpock

Thanks for all your time and help my friend.

T. Valko said:
In that case I would just use an additional cell (the same cell on each
sheet) with a formula like this:

F22:

=--(E22>1000)

Then on your summary sheet:

=SUM('1:31'!F22)
 

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

Top