Thread: subtract a single cell from range of cells and then count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tworrall tworrall is offline
external usenet poster
  
Posts: 5
Default subtract a single cell from range of cells and then count
I want to subtrcat a single cell from each value in a range. For each result,
if greater tthan 30, I want to count those instances.

In other words, I would subtract A2 from E:E (each cell). I want to count
each time the result is greater than 30.
Reply With QuoteReply With Quote