Thread: =SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chubbybat chubbybat is offline
external usenet poster
  
Posts: 7
Default =SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding
HI there,

I am so close but this will not add any values.
I do ctrl shift enter and it accepts the formula but I only get a 0.
Any ideas? Time cell is formatted as time and Friday is formatted as
General.
Reply With QuoteReply With Quote