Thread: subtract a single cell from range of cells and then count
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default subtract a single cell from range of cells and then count
Check your previous post

=SUMPRODUCT((A2-E1:E10030)*(E1:E1000))

If this post helps click Yes
---------------
Jacob Skaria


"tworrall" wrote:

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