Then eliminate the $D$2:$D$100 argument. It would be just:
=SUMPRODUCT(($B$2:$B$100="New")*($C2:$C$100="R18") )

--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"MikeE" wrote:

There is no $ value assigned. So the result just needs to count the all of
the "new" to the appropriate store.

"John C" wrote:

Sumproduct, assuming Sales in column B, store number in column C, and dollar
amount in column C.

=SUMPRODUCT(--($B$2:$B$100="New"),--($C2:$C$100="R18"),($D$2:$D$100))


--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"MikeE" wrote:

Can anyone help me?
I have two columns, first one lists several types of sales as text; "NEW",
"NRE", "CPE" etc... the second column lists store numbers; "R18", "R41"
etc... I need a formula that will extract the desired information from the
data for each sales type to each store number. The data comes lumped
together, so I need to know how many "NEW" sales belong to "R18" for example.
Is this possible?