Thread: How Can i combine
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Monty Monty is offline
external usenet poster
  
Posts: 33
Default How Can i combine
How Can i combine the following into one cell:-

=COUNTIF('Mar 07'!$I$1:$I$527,2001)

=COUNTIF(H:H,"5") - COUNTIF(H:H, "<0")

Any help Please
Monty
Reply With QuoteReply With Quote