Add 2 Range Names

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to add FoodINGR_Costs_inQuery TO Food_Costs_inQuery below,
seems easy but I keep getting a #Value error


=IF(COUNTIF(Restaurant_Names_inQuery,"="
&$A7)<1,"-",SUMIF(Restaurant_Names_inQuery,"="&$A7,Food_Costs_inQuery)/SUMIF
(Restaurant_Names_inQuery,"="&$A7,Sales_Revenue_inQuery))

My attempt which produces the #Value error was

=IF(COUNTIF(Restaurant_Names_inQuery,"="
&$A7)<1,"-",SUMIF(Restaurant_Names_inQuery,"="&$A7,(Food_Costs_inQuery,FoodI
NGR_Costs_inQuery))/SUMIF(Restaurant_Names_inQuery,"="&$A7,Sales_Revenue_inQ
uery))


Thanks
 
Figured it out


John said:
I am trying to add FoodINGR_Costs_inQuery TO Food_Costs_inQuery below,
seems easy but I keep getting a #Value error


=IF(COUNTIF(Restaurant_Names_inQuery,"="
&$A7)<1,"-",SUMIF(Restaurant_Names_inQuery,"="&$A7,Food_Costs_inQuery)/SUMIF
(Restaurant_Names_inQuery,"="&$A7,Sales_Revenue_inQuery))

My attempt which produces the #Value error was

=IF(COUNTIF(Restaurant_Names_inQuery,"="
&$A7)<1,"-",SUMIF(Restaurant_Names_inQuery,"="&$A7,(Food_Costs_inQuery,FoodI
NGR_Costs_inQuery))/SUMIF(Restaurant_Names_inQuery,"="&$A7,Sales_Revenue_inQ
uery))


Thanks
Click to expand...
 
Back
Top