Posted to microsoft.public.excel.worksheet.functions

Vince

external usenet poster

Posts: 102

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)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMPRODUCT returns 0, when I know it shouldn't	Tim Bridle	Excel Worksheet Functions	5	January 20th 07 04:03 PM
if statements with multiple returns	Batman	Excel Worksheet Functions	7	November 26th 06 12:41 AM
SumProduct Returns Zero	ronnomad	Excel Worksheet Functions	4	August 10th 06 02:45 PM
sumproduct returns zero	vacation	Excel Worksheet Functions	7	January 31st 06 07:56 PM
returns calculation using sumproduct	Stan Altshuller	Excel Worksheet Functions	6	January 13th 05 12:25 AM

All times are GMT +1. The time now is 12:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us