Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am using the countif formula to count the Xs in each column -
What I really want is a total that counts the Xs in a column and then multiplies that count by a number, i.e.: Column Q x 1, Column R x 2, Column S x 3, Column T x 4, etc. Can I add to the countif formula to count the Xs in column T and multiply by 4 so a total for column T would be 4 instead of 1. P Q R S T 7 X 8 X 9 X 10 X 11 X Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting occurances and multiplying by a quantity | Excel Discussion (Misc queries) | |||
Rounding and Multiplying | Excel Discussion (Misc queries) | |||
Multiplying | Excel Discussion (Misc queries) | |||
multiplying with excell | Excel Worksheet Functions | |||
Multiplying in a row | Excel Discussion (Misc queries) |