View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default conditional formula in terms of cell formats

Write a formula based on the logic of *why* the numbers are white.

--
Biff
Microsoft Excel MVP


"bd" wrote in message
...
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?