Posted to microsoft.public.excel.misc

Karen Smith Karen Smith is offline

external usenet poster

Posts: 45

SUMPRODUCT Question

I'm trying to use this formula, but its not working, what am i doing wrong?

=SUMPRODUCT(--('The Worker Be!'!A3:A99=C9),--('The Worker
Be'!d3:d99)=E7),'The Worker Be'!aa3:aa99)

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 Question	porter444	Excel Worksheet Functions	2	September 25th 07 07:06 PM
question on SUMPRODUCT ??	JE McGimpsey	Excel Discussion (Misc queries)	4	February 11th 07 04:54 PM
Sumproduct question	Barb Reinhardt	Excel Worksheet Functions	3	November 17th 06 06:53 PM
Sumproduct question	Brad	Excel Worksheet Functions	2	November 1st 06 07:32 PM
Sumproduct question	Daniel Bonallack	Excel Worksheet Functions	3	September 16th 05 07:13 AM

All times are GMT +1. The time now is 03:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us