subtract a single cell from range of cells and then count
ps
Alter the range to suit
"winnie123" wrote:
Hi,
you can copy value in A2 and then highlight the range in column E, paste
special then click on subtract.
To get the count use formula in F2 or where desired
=COUNTIF(E2:E8,"30")
"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.
|