SUMIF Multiple Conditions

Im trying to have a formula look at two diferent columns and if they meet the criteria add the third column.

I tried using sumproduct but It wont give me anything but error messages or a zero.

Looks like this
=SUMPRODUCT(A:A="Stewart",(G:G="Fiduciary"),C:C)

Need it to say:
if column A = Stewart and Column B = Fiduciary then add up the amount in Column C

First, SUMPRODUCT does not work on entire column references. If you want to reference the entire column, try A1:A65536.

Your formula should look like this:

Please Login or Register  to view this content.

Try that and report back

Here's my exact formula. It returns a zero no matter what I do.

=SUMPRODUCT((DataQTD!A1:A10000="Charles Stewart"),(DataQTD!G1:G10000="Fiduciary"),DataQTD!C1:C10000)

Thanks for your help

Maybe this is a good moment to ask

Is there any way to put something like instead of A:A

A2:A(count....) so range would change as there a datas...

Originally Posted by DonkeyOte

BigBas, your point re: entire column references holds true only up to XL2007, also using 65536 won't help, you would need to use 65535 (XL will convert A1:A65536 to A:A) but as stated you should not use large ranges with Arrays full stop.

True on all counts...

Beautiful! That worked.... thanks!

i have some data to moniter its daily transaction

Date wise+item code wise sum
project Wise +item code wise sum

itemRegister
Date Project # Item Code Description Unit QtyRec Qty Issue

Summery Report

Item Code Description Unit Total QtyRec Total Qty Issue

01/10/11
15/10/11
Item Code Description Unit Total QtyRec Total Qty Issue


i am using sumproduct funcation but it slow down the work sheet while calculation.

Kindly gudie how to do all this .

noor

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Originally Posted by arthurbr

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

i try to post new but it mistakenly posted here. but try to reply i realy need resolve this issue

Please start a new thread - Thread closed