View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BD BD is offline
external usenet poster
 
Posts: 16
Default conditional formula in terms of cell formats

I have a sheet with some numbers in white and some in black. I can use the
"find" function to isolate and find the white numbers and then manually add
all of them up separately. How could I directly write a formula in a cell to
sum up all the white numbers?