Thread: SumIf formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BarbS via OfficeKB.com BarbS via OfficeKB.com is offline
external usenet poster
 
Posts: 2
Default SumIf formula

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(D5:D1000,"=Housing",H5:I1000,0)) but it only gave me the
answer €œ0€. I also tried =SUMIF(D5:D1000,"Housing",H5:I1000) that also gives
me a €œ0€ answer. If I leave out the €œCost€ in the formula, I get the right
total. Its 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(I60,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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200811/1