Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
texansgal texansgal is offline
external usenet poster
 
Posts: 34
Default Formula

I am trying ot put in a formula. I have a two columns with Revenue listed.
One is the Estimate, one is the actual. If there is not an amount in the
Actual amount column, I added the cell that was in the Estimate cell.

I color coded the cell because I am breakingit out by Sales Person. I have 3
Sales People. I went in and did the SUM and went into each cell that is
colored coded to each person. I am getting an error.

Please help.

Thanks,
Vanessa