SUMIF(AND()
 

I have a sheet with 3 columns

Value Status Type

I want to be able to get total values from these columns based on a
combination of Status and Type.

If a job meets the type criteria, is it complete, incomplete, receivable,
etc??

I currently have a SUMIF formula for Status and another for Type, but need
to combine the functions.

Any suggestions would be appreciated.

DRD

SUMIF(AND()
 

Try

=SUMPRODUCT(--(Status_range=criteria1),--(Type_range=criteria2),Value_range)

will sum the value range where status and type are true

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"David R. Duggan" wrote in message
...
I have a sheet with 3 columns

Value Status Type

I want to be able to get total values from these columns based on a
combination of Status and Type.

If a job meets the type criteria, is it complete, incomplete, receivable,
etc??

I currently have a SUMIF formula for Status and another for Type, but need
to combine the functions.

Any suggestions would be appreciated.

DRD