Summing a VLOOKUP formula

[jmcole]

I am using the following formula in cell C53 on the Departmental tab of my spreadsheet:

=IFERROR(VLOOKUP(B53,Auditor!$B$3:$T$200,4,0),0)

The problem I am having is that there are 2 entries for B53 (department 10) on the Auditor tab. One cell has 0.00 and the other has 1,382,750.55. The formula that I am using returns 0.00. I need the formula to add each of these because sometimes they both have a dollar amount in them.

While I’m asking for help…….What would really be great…..

Is it possible to have Excel look on the Auditor tab for B53 (department 10) in column B, look for TY INVENTORY in the heading, and produce the corresponding dollar amount? The reason for this is that the auditor changes the order of the spreadsheet from time to time.

[sourabhg98]

Maybe this would help--
=SUMIF(Inventory!A$6:A$172,B53,Inventory!R$6:R$172)

[sourabhg98]

Oops I wrote the formula for D53,
It should be this for C53-
=SUMIF(Auditor!$B$3:$B$200,B53,Auditor!$E$3:$E$200)

[jmcole]

Oops I wrote the formula for D53,
It should be this for C53-
=SUMIF(Auditor!$B$3:$B$200,B53,Auditor!$E$3:$E$200)

Thank you very much, works perfectly for the initial question. I'm going to keep this open for a little bit to see if the second question can be accomplished.