count if

  • Thread starter Thread starter MrSpock
  • Start date Start date
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
 
Assuming your sheet names are 1, 2, 3, 4 .... 31

=SUMPRODUCT(COUNTIF(INDIRECT("'"&ROW(INDIRECT("1:31"))&"'!E22"),">1000"))
 
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.
 
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)
 
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)
Click to expand...
 
Back
Top