Biff's formula work, don't worry about the help, MS had no clues it could
work this way when the help was written, you just need to adapt it

=SUMPRODUCT(--(G3:G215 = "Salespersons Name"),--( J3:215 = "Quote Status),
I3:I215)

will retrun any number from I3:I215 (I assume you had a type and not I15
because it needs ti be the same size
as the other 2)

If the values in I3:I215 are text

=INDEX( I3:I215,MATCH(1,(G3:G215 = "Salespersons Name")*(J3:215 = "Quote
Status),0))

entered with ctrl + shift & enter

it would be better to replace the criteria like "Salespersons Name" with for
instance A3 or any other cell and put the criteria in that cell, do the same
for quiote status, that way you don't have to edit the formula when you
change sales person name

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"Melanie" wrote in message
...
I tried your formula for the project i am working on it didnt quite give me
the answer i needed.

The formula i need is more like IF G3:G215 = "Salespersons Name" and If
J3:215 = "Quote Status" then find the corrosponding figure from I3:I15.

This is why i orginally tried SUMIF only to find i couldn't get it to do
two
ranges each with a corrosponding condition to find a combined total from.

I'm not sure if what i am asking makes any sense.

Also when i looked at SUMPRODUCT function in the help menu i found this
multiplies the value im after the total with both conditions applied with
no
modifications.

"Biff" wrote:

Hi!

Try something like this:

Condition 1 = Yes
Condition 2 = 100
C1:C100 = range to sum

=SUMPRODUCT(--(A1:A100="Yes"),--(B1:B100=100),C1:C100)

Notice that the TEXT condition is enclosed in quotes and the NUMERIC
condition is not.

Biff

"Melanie" wrote in message
...
I've tried the SUMIF function but i really need to get one figure with
two
different conditions each coming from a different column and i can't
quite
find anything to do the job. Can you please help me?