Posted to microsoft.public.excel.misc

Tufail

external usenet poster

Posts: 168

error sumproduct #value!

hello all,
i am using following sumproduct formula ang facing this error #value !
=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))
coulmns "P" contaning formula as under:
Col_N Col_O Col_P
9,00 114.14 1,090,000.

thanks in advance

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 Error	Kate	Excel Discussion (Misc queries)	5	June 25th 08 02:37 PM
error in SUMPRODUCT	Tufail	Excel Discussion (Misc queries)	8	December 17th 07 12:03 AM
SUMPRODUCT #VALUE! Error	juliejg1	Excel Worksheet Functions	2	December 13th 07 04:25 PM
#ref error with Sumproduct	[email protected]	Excel Worksheet Functions	5	October 9th 06 07:00 PM
SUMPRODUCT ERROR	Mestrella31	Excel Discussion (Misc queries)	1	January 26th 05 08:01 PM

All times are GMT +1. The time now is 02:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us