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?