Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count cells with length not equal to 7 | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions |