Add 2 Range Names

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
 
J

John

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add Sum of 2 Range Names 2
SUMPRODUCT COUNTIF Problem 7
Help with code statement 1
Sum a range of cells starting from an offset date list from TODAY() 3
Count in a variable range 4
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
SUMPRODUCT Formula 6
vlookup or index/match formula?? 2

Top