| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif based on different values in different cells
How do I sum only the numbers in Col B that are not associated with 0 in Col
C. That is, how do I get a sum of 40.4% (22.1+15.4+13.6). Thanks very much. Col A Col B Col C Cat A 10.4% 0.0% Cat B 9.5% 0.0% Cat C 9.5% 0.0% Cat D 22.1% 0.1% Cat E 12.3% 0.0% Cat F 10.8% 0.0% Cat G 15.4% 8.9% Cat H 2.9% 13.6% Cat I 3.5% 0.0% Cat J 3.5% 0.0% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum the values of a range based upon multiple ranges and criteria | Excel Worksheet Functions | |||
| help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Threaded Mode
