sumproduct

S

Sarah

Any help would be appreciated:

I have a spreadsheet with company salaries on it. The
sheet has multiple positions. I have position titles
column C and pay rates in column D. The sheet that holds
the raw data is "Store Hourly." My goal is to count the
number of cashiers earning 6<x<=6.25. ($A3 is the field
that holds the word "Cashier".)

This is where I am stuck (I think sumproduct may not be
the way to go):

=SUMPRODUCT(('Store Hourly'!$C$2:$C$4592=$A3)*('Store
Hourly'!$D$2:$D$4592<=6.25)*('Store Hourly'!
$D$2:F$4592>6))

I appreciate your time.
 
D

Domenic

Hi Sarah,

Try,

=SUMPRODUCT(('Store Hourly'!$C$2:$C$4592=$A3)*('Store
Hourly'!$D$2:$D$4592>6)*('Store Hourly'!$D$2:$D$4592<=6.25))

Hope this helps!
 
H

Harlan Grove

...
...
. . . My goal is to count the
number of cashiers earning 6<x<=6.25. ($A3 is the field
that holds the word "Cashier".)

This is where I am stuck (I think sumproduct may not be
the way to go):

=SUMPRODUCT(('Store Hourly'!$C$2:$C$4592=$A3)
*('Store Hourly'!$D$2:$D$4592<=6.25)
*('Store Hourly'!$D$2:F$4592>6))
Click to expand...

As written, I believe you have a typo in the last term. Try changing

('Store Hourly'!$D$2:F$4592>6)

to

('Store Hourly'!$D$2:$D$4592>6)
 
J

jeff

Hi,Sarah,

I tried your formula on a small dataset - it seems
perfect to me except the last part is wrong - no $F,
but $D

$D$2:F$4592>6))


jeff
 
S

Sarah

THANKS TO ALL!!!!
-----Original Message-----
Hi,Sarah,

I tried your formula on a small dataset - it seems
perfect to me except the last part is wrong - no $F,
but $D

$D$2:F$4592>6))


jeff
.
Click to expand...
 
Top