Posted to microsoft.public.excel.programming

hellZg8

external usenet poster

Posts: 26

Sumproduct with two conditions(or more)

This is a formula that I have now

=sumproduct((B2:B2002)="Machine")*(Year(A2:A2002)= 2006)
*(Month(A2:A2002)=1)*J2:J2002)

this works great (thanks to every one on this forum)

any ways I would like to add another condition in there.I tried the
following but
holy what a number did I get

=sumproduct((B2:B2002="Machine")*(C2:C2002="Repair s")*(Year(A2:A2002)=2006)*(Month(A2:A2002)=1)*J2:J 2002)

any help in the right direction will be greatly apprec.

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 with 4 conditions	EXCELably Challenged[_2_]	Excel Worksheet Functions	1	March 19th 10 10:46 PM
Sumproduct with conditions	EZ[_2_]	Excel Worksheet Functions	0	December 10th 09 03:52 PM
SUMPRODUCT with conditions	sahafi	Excel Worksheet Functions	3	November 30th 06 10:32 PM
Conditions in sumproduct	Antonio	Excel Worksheet Functions	3	October 26th 06 03:18 AM
sumproduct three conditions	Scire	Excel Worksheet Functions	3	May 9th 06 06:22 PM

All times are GMT +1. The time now is 08:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us