Remember Me? November 16th 08, 07:21 PM posted to microsoft.public.excel.worksheet.functions
 BarbS via OfficeKB.com external usenet poster First recorded activity by ExcelBanter: Nov 2008 Posts: 2 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 1000,"=Housing",H5:I1000,0)) but it only gave me the
answer â0â. I also tried =SUMIF(D5 1000,"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(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 November 16th 08, 07:36 PM posted to microsoft.public.excel.worksheet.functions
 Mike H external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501 SumIf formula

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

"BarbS via OfficeKB.com" wrote:

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 1000,"=Housing",H5:I1000,0)) but it only gave me the
answer â0â. I also tried =SUMIF(D5 1000,"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(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

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post jerrymcm Excel Discussion (Misc queries) 2 October 3rd 07 03:35 PM kcip Excel Worksheet Functions 1 May 3rd 07 07:41 AM StephenAccountant Excel Discussion (Misc queries) 5 November 9th 06 04:11 AM BiggyTwo Excel Worksheet Functions 3 March 18th 06 02:36 AM tlc Excel Discussion (Misc queries) 2 March 13th 06 08:07 PM

All times are GMT +1. The time now is 06:54 AM. Copyright ©2004-2020 ExcelBanter.