I am trying to add all sales for four given Market Segments on a refreshable
spreadsheet into a static sheet.

Commissions Sheet (refreshable)
Date Sold Sell Market Seg
1/3/05 $11,672.00 Professional Photogr
1/3/05 $4,425.00 Digital Printer
1/1/05 $300.00 Fine Art Repro
12/31/04 $124.00 Professional Photographer

I want to add all sales for January that equal the following keywords in the
Market Segment Column:
Professional Photographer
Professional Photogr
Fine Art
And add them to a field on the static sheet (Dashboard).

Then I also want to be able to do the same for all others that are not
included in the first lookup and display them another field on Dashboard.

Here is the formula I am using to calculate all sales in January. I am
trying to figure out how to add the second part to the equation.

=SUMPRODUCT(--(MONTH(Commissions!$B$2:$B$3) = 1), Commissions!$E$2:$E$3)

Thank you for any help that can be given,
PETE

=SUMPRODUCT(--(TEXT(Commissions!$B$2:$B$5,"mmm-yy")
="Jan-05"),--ISNUMBER(MATCH(Commissions!$C$2:$C$5,$E$2:$H$2,0)) ,
Commissions!$E$2:$E$3)

where E2:H2 houses the conditions Professional Photographer,
Professional Photogr, and Fine Art.

Pete Petersen wrote:
I am trying to add all sales for four given Market Segments on a refreshable
spreadsheet into a static sheet.

Commissions Sheet (refreshable)
Date Sold Sell Market Seg
1/3/05 $11,672.00 Professional Photogr
1/3/05 $4,425.00 Digital Printer
1/1/05 $300.00 Fine Art Repro
12/31/04 $124.00 Professional Photographer

I want to add all sales for January that equal the following keywords in the
Market Segment Column:
Professional Photographer
Professional Photogr
Fine Art
And add them to a field on the static sheet (Dashboard).

Then I also want to be able to do the same for all others that are not
included in the first lookup and display them another field on Dashboard.

Here is the formula I am using to calculate all sales in January. I am
trying to figure out how to add the second part to the equation.

=SUMPRODUCT(--(MONTH(Commissions!$B$2:$B$3) = 1), Commissions!$E$2:$E$3)

Thank you for any help that can be given,
PETE

Thank you for the help...it works.

"Aladin Akyurek" wrote:

=SUMPRODUCT(--(TEXT(Commissions!$B$2:$B$5,"mmm-yy")
="Jan-05"),--ISNUMBER(MATCH(Commissions!$C$2:$C$5,$E$2:$H$2,0)) ,
Commissions!$E$2:$E$3)

where E2:H2 houses the conditions Professional Photographer,
Professional Photogr, and Fine Art.

Pete Petersen wrote:
I am trying to add all sales for four given Market Segments on a refreshable
spreadsheet into a static sheet.

Commissions Sheet (refreshable)
Date Sold Sell Market Seg
1/3/05 $11,672.00 Professional Photogr
1/3/05 $4,425.00 Digital Printer
1/1/05 $300.00 Fine Art Repro
12/31/04 $124.00 Professional Photographer

I want to add all sales for January that equal the following keywords in the
Market Segment Column:
Professional Photographer
Professional Photogr
Fine Art
And add them to a field on the static sheet (Dashboard).

Then I also want to be able to do the same for all others that are not
included in the first lookup and display them another field on Dashboard.

Here is the formula I am using to calculate all sales in January. I am
trying to figure out how to add the second part to the equation.

=SUMPRODUCT(--(MONTH(Commissions!$B$2:$B$3) = 1), Commissions!$E$2:$E$3)

Thank you for any help that can be given,
PETE