SumIf formula

[BarbS via OfficeKB.com]

I need to create a function on this table that will sum the “Cost†+ “Priceâ€
based on the “Category†entered.

For instance, each time Housing is selected in “Categoryâ€, I what to total
the corresponding amounts in H (Cost) + I(Price).

I tried =SUM(IF(D51000,"=Housing",H5:I1000,0)) but it only gave me the
answer “0â€. I also tried =SUMIF(D51000,"Housing",H5:I1000) that also gives
me a “0†answer. If I leave out the “Cost†in the formula, I get the right
total. It’s only when I include the “Cost†that I get the answer “0â€.
Creating it as an array formula gives me “0†for an answer also.

D E F H I J
Category Type Vendor Cost Price Cost+Price
D:F are Lookups

H =IF(E5="TPD","$2.00","$0.00") J =IF(I6>0,J5+H6+I6,
"")

Does the formula in “Cost†restrict me from using the data in the Sum formula?
If so how do I get around it?
Thank you for your help. barb

 

[Mike H]

Hi,

Your data has wrapped in posting so it's difficult but I assume this is your
cost formula

=IF(E5="TPD","$2.00","$0.00")

Putting the output in quites makes it Text so try this
=IF(E5="TPD",$2.00,$0.00)

Mike