Thread: #Value Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M Thompson M Thompson is offline
external usenet poster
 
Posts: 37
Default #Value Error

Hi

I am getting a #value error. The worksheet is set up horizontally. These
are the formulas:

At the quarter, I have =If(H33="","Quarterly",D33+F33+H33), and so on at
each quarter.

At the end, the formula in AB33 is
=Sum(D33-E33+F33-G33+H33-I33+J33-K33,etc...)

I guess it doesn't like the "quarterly" business. Can anyone give me
something I can understand that will work around the problem??

Thanks for you help!
--
OneFineDay