Why this SUMPRODUCT statements returns zero?

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

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)
 
=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,

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
 
Thanks Mike, that was all it took! Sometimes the easiest and smallest things
trip you up the most!

Thanks again,
 
Back
Top