sumproduct

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 6x=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$45926))

I appreciate your time.

Hi Sarah,

Try,

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

Hope this helps!

In article ,
"Sarah" wrote:

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 6x=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$45926))

I appreciate your time.

"Sarah" wrote...
...
. . . My goal is to count the
number of cashiers earning 6x=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$45926))

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

('Store Hourly'!$D$2:F$45926)

to

('Store Hourly'!$D$2:$D$45926)

--
To top-post is human, to bottom-post and snip is sublime.

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$45926))


jeff
-----Original Message-----
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 6x=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$45926))

I appreciate your time.
.

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$45926))


jeff
-----Original Message-----
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 6x=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$45926))

I appreciate your time.
.

.