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