Why this SUMPRODUCT statements returns zero?
 

Worksheet has following structure and I am trying to create statement that
states if year = 2007, AND account = 57110, sum amounts. The statement below
returns a zero. Any suggestions?

Thanks in advance


Column C Column G Column F
10/17/2007 11-70-34180-57110 $550.00

SUMPRODUCT(--(YEAR(C6:C6550)=2007),--(RIGHT($G$6:$G$6550,5)=57110),$F$6:$F$6550)

Why this SUMPRODUCT statements returns zero?
 

=SUMPRODUCT(--(YEAR(C6:C6550)=2007),--(RIGHT($G$6:$G$6550,5)="57110"),$F$6:$F$6550)

perhaps

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Vince" wrote in message
...
Worksheet has following structure and I am trying to create statement that
states if year = 2007, AND account = 57110, sum amounts. The statement
below
returns a zero. Any suggestions?

Thanks in advance


Column C Column G Column F
10/17/2007 11-70-34180-57110 $550.00

SUMPRODUCT(--(YEAR(C6:C6550)=2007),--(RIGHT($G$6:$G$6550,5)=57110),$F$6:$F$6550)

Why this SUMPRODUCT statements returns zero?
 

Vince,

If your dates are formatted correctly then its going wrong on the 57110
which will be text so try this

=SUMPRODUCT(--(YEAR(C6:C6550)=2007),--(RIGHT($G$6:$G$6550,5)="57110"),$F$6:$F$6550)


Mike

"Vince" wrote:

Worksheet has following structure and I am trying to create statement that
states if year = 2007, AND account = 57110, sum amounts. The statement below
returns a zero. Any suggestions?

Thanks in advance


Column C Column G Column F
10/17/2007 11-70-34180-57110 $550.00

SUMPRODUCT(--(YEAR(C6:C6550)=2007),--(RIGHT($G$6:$G$6550,5)=57110),$F$6:$F$6550)

Why this SUMPRODUCT statements returns zero?
 

Thanks Mike, that was all it took! Sometimes the easiest and smallest things
trip you up the most!

Thanks again,

"Mike H" wrote:

Vince,

If your dates are formatted correctly then its going wrong on the 57110
which will be text so try this

=SUMPRODUCT(--(YEAR(C6:C6550)=2007),--(RIGHT($G$6:$G$6550,5)="57110"),$F$6:$F$6550)


Mike

"Vince" wrote:

Worksheet has following structure and I am trying to create statement that
states if year = 2007, AND account = 57110, sum amounts. The statement below
returns a zero. Any suggestions?

Thanks in advance


Column C Column G Column F
10/17/2007 11-70-34180-57110 $550.00

SUMPRODUCT(--(YEAR(C6:C6550)=2007),--(RIGHT($G$6:$G$6550,5)=57110),$F$6:$F$6550)