View Single Post
  #1   Report Post  
ellebelle
 
Posts: n/a
Default COUNT IF NOT EQUAL TO ZERO

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?