Sumif doesn't work for multiple conditions, but you can use sumproduct.

=SUMPRODUCT(--(qry_FY06_COMMISSION_BUDGET_INFO!B2:B30000 =
"07")*--(qry_FY06_COMMISSION_BUDGET_INFO!H2:H30000=900)*(q ry_FY06_COMMISSION_BUDGET_INFO!O2:O30000))

Remember that the above formula will wrap, copy it all.

Cheers,
Jason Lepack

On Jan 24, 11:28 am, dnorthcutt
wrote:
Jason Lepack,

Thank you so much for that info, it worked. Now I tried to add something to
the sumiff but it is giving me a compile error=expected:line number,or label,
or statement or end of statement.
Here is what I put in originall and it worked:

=SUMIF(qry_FY06_COMMISSION_BUDGET_INFO!H2:H30000,9 00,qry_FY06_COMMISSION_BU*DGET_INFO!O2:O30000)
this is giving me the sum for all 900 entries

Now I tried to add another parameter and it gives me the above error.
=SUMIF(qry_FY06_COMMISSION_BUDGET_INFO!H2:H30000,9 00,qry_FY06_COMMISSION_BU*DGET_INFO!B2:B30000,07,q ry_FY06_COMMISSION_BUDGET_INFO!O2:O30000)

qry_FY06_COMMISSION_BUDGET_INFO!B2:B30000,07 was added as another
paramenter. I needed all 900 amounts that were 07

Any help you can give me in this is greatly appreciated.



"Jason Lepack" wrote:
All you need is sumif

=sumif(sheetname!rangewiththe900s,900,sheetname!ra ngethatyouwanttoadd)

Cheers,
Jason Lepack
dnorthcutt wrote:
I have taken a qry from access and exported it into excel and am now trying
to come up with a formula in excel. I have 3 sheets in my workbook and I am
trying to come up with a one cell sum from the data in one of the other
sheets. My conditions are if this column in sheet a=(this sheet has a very
long name) has a 900 in it then take the figure from this other column in
sheet a and sum it into this column in sheet b. There are many figures in
one sheet and I want it to sum into a cell in another sheet. Please help- Hide quoted text -- Show quoted text -