Posted to microsoft.public.excel.misc

freebee

external usenet poster

Posts: 19

sumproduct across worksheets

Hi, I have the following formula in cell A1, sheet 1:
=sumproduct--('sheet2'!a1:a10="apple"),--('sheet2'!b1:b10="orange"),--('sheet2'!c1:c10)
1.how do I simplify this formula
2.can i include another sumproduct formula from sheet 3
Pls. help
Thanks.

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 using criteria from 2 worksheets	brownmre	Excel Worksheet Functions	1	February 10th 09 11:24 PM
Sumproduct across multiple worksheets	Paul	Excel Worksheet Functions	3	December 20th 08 04:40 AM
Sumproduct across worksheets	mikelee101[_2_]	Excel Worksheet Functions	3	January 31st 08 09:34 PM
Sumproduct across multiple worksheets	woodcockmolely	Excel Worksheet Functions	3	August 30th 06 09:28 AM
SUMPRODUCT across worksheets	Stephen POWELL	Excel Discussion (Misc queries)	3	January 25th 05 02:25 AM

All times are GMT +1. The time now is 04:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us