Posted to microsoft.public.excel.misc

EricBB

external usenet poster

Posts: 50

Replace SUMIF with SUMPRODUCT

=SUMPRODUCT(--('Sheet1'!$E$164:$E$171=$A9),'Sheet1'!$F$164:$F
$171)+SUMPRODUCT(--('Sheet1'!$E$130:$E$156=$A9),'Sheet1'!$F$130:$F$15 6)

"torooo" wrote:

Thanks Peo for responding...

Here is the short version of the formula

=SUMIF('Sheet1'!$E$164:$E$171,$A9,'Sheet1'!$F$164: $F
$171)+SUMIF('Sheet1'!$E$130:$E$156,$A9,'Sheet1'!$F $130:$F$156)

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
Replace SUMIF with SUMPRODUCT	torooo	Excel Worksheet Functions	14	December 8th 07 11:25 PM
sumproduct? sumif(sumproduct)?	David	Excel Worksheet Functions	3	July 13th 07 07:06 PM
Help for sumif / sumproduct	jitu_tikili	Excel Worksheet Functions	5	April 4th 06 06:59 PM
sumif vs sumproduct	ww	Excel Worksheet Functions	2	April 5th 05 02:19 AM
SUMIF or SUMPRODUCT or something else?	\|\| cypher \|\|	Excel Worksheet Functions	7	November 9th 04 10:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us