Thread: why doesn't excel count "numbers" in an IF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noddy2011 Noddy2011 is offline
external usenet poster
  
Posts: 3
Default why doesn't excel count "numbers" in an IF formula
My formula is =IF(AND(0<J3,J3<6),J3+1,"6") but when i use sum to add the
cells together is doesn't count any cell with "6" in. Why is this and how do
i change this please.
Reply With QuoteReply With Quote