Another Question Frank

[romeo1mike]

Thanks Frank, is it possible to add another criteria like location t
that... so in the end it would be B2:B10, "Steve" and C2:C10 "Spain
then sum, A2:A10.... Is that possible to have two criteria to mee
before adding up the sales??? Thanks agai

 

[William]

Hi romeo1mike

=Sumproduct((B2:B10="Steve")*(C2:C10="Spain")*(A2:A10))

--
XL2002
Regards

William

(e-mail address removed)

| Thanks Frank, is it possible to add another criteria like location to
| that... so in the end it would be B2:B10, "Steve" and C2:C10 "Spain"
| then sum, A2:A10.... Is that possible to have two criteria to meet
| before adding up the sales??? Thanks again
|
|
| ---
| Message posted
|

 

[Bob Phillips]

See reply in other thread.

Please keep to thread so that the continuity and context is maintained.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

Thanks Frank, is it possible to add another criteria like location to
that... so in the end it would be B2:B10, "Steve" and C2:C10 "Spain"
then sum, A2:A10.... Is that possible to have two criteria to meet
before adding up the sales??? Thanks again

It seems to me a Pivot Table would be ideal for this.

If your columns are labeled Sales, Salesperson and Country, you could create a
Pivot table with Salesperson in the Rows area; Country in the Columns area; and
Sales (using the SUM setting) in the Data area.


--ron