Posted to microsoft.public.excel.misc

George A. Jululian[_2_] George A. Jululian[_2_] is offline

external usenet poster

Posts: 89

Excel Jululian

Please help in this formula

{=SUM(('[Summary1.xls]A1 1-3'!$C$3:$C$19268=B$11)*('[Summary1.xls]A1
1-3'!$E$3:$E$19268=$A9)*('[Summary1.xls]A1
1-3'!$G$3:$G$19268=$H3)*'[Summary1.xls]A1 1-3'!$S$3:$Y$19268)}
the result should read 24 anf it give 0

please advise
regards

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
Excel Jululian	George A. Jululian[_2_]	Excel Discussion (Misc queries)	1	February 10th 10 04:07 PM
Jululian Excel	George A. Jululian[_2_]	Excel Discussion (Misc queries)	15	November 10th 09 07:21 AM
Jululian Excel	George A. Jululian[_2_]	Excel Discussion (Misc queries)	3	November 8th 09 10:49 AM
Jululian Excel	George A. Jululian[_2_]	Excel Discussion (Misc queries)	2	November 7th 09 08:48 AM
Excel Jululian	George A. Jululian[_2_]	Excel Discussion (Misc queries)	8	February 24th 09 12:56 PM

All times are GMT +1. The time now is 01:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us