View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default sum only if a certain cell contains a date

Something like:
=a1+if(b10,c1,0)
?

Regards,
Fred.

"mimsly17" wrote in message
...
I am trying to include a figure in a sum but I only want to count it if a
date appears in another cell.