Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT returns 0, when I know it shouldn't | Excel Worksheet Functions | |||
if statements with multiple returns | Excel Worksheet Functions | |||
SumProduct Returns Zero | Excel Worksheet Functions | |||
sumproduct returns zero | Excel Worksheet Functions | |||
returns calculation using sumproduct | Excel Worksheet Functions |