Posted to microsoft.public.excel.newusers

Joe Gieder Joe Gieder is offline

external usenet poster

Posts: 73

SUMPRODUCT Problem

First, thank you in advance for your help and looking at this.

I'm trying to use this formula to sum the values in cells D4:D4650 based on
the criteria that the date in cells B4:B4650 is from 2006 and it has not been
rejected (E4:E4650).
=SUMPRODUCT(--(B4:B4650=YEAR(2006)),--(E4:E4650<"Rejected"),(D4:D4650))

The problem with this formula is that it returns $0.00 and it should be over
$5m.

TIA for your help
Joe

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 Problem	Gos-C	Excel Worksheet Functions	13	February 10th 06 07:07 PM
sumproduct problem	Stefan	Excel Worksheet Functions	2	January 5th 06 10:59 AM
Sumproduct Problem	Andibevan	Excel Worksheet Functions	4	August 17th 05 09:39 AM
sumproduct problem	christophe meresse	Excel Worksheet Functions	3	July 30th 05 02:23 PM
Another Sumproduct & #N/A problem	Dave Davis	Excel Worksheet Functions	3	January 10th 05 03:59 PM

All times are GMT +1. The time now is 08:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us