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?
|