View Single Post
  #3   Report Post  
ellebelle
 
Posts: n/a
Default

thanks - silly question but how do you inset greater than zero in a function
OR does not equal zero?

e

"Max" wrote:

Assuming the sample data is in A2:B4
Try: =SUMPRODUCT((A2:A4)*(B2:B4<0))

Adapt the ranges to suit. Note that you can't use entire col references
(A:A, B:B, etc) in SUMPRODUCT
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ellebelle" wrote in message
...
I would like to count the number of cells in a column that does not equal
zero and then multiply each count by an adjacent number.

EG.
no of shots days per shot
6 3
0 0
3 5

i want to calculate the "days per shot" column that does not equal zero

and
then multiply each count by the no. of shot. therefore 1*6+1*3 = 9.

The main problem i am having is how to count when something does not equal

a
certain argument - COUNTIF NOT????

any ideas?