Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have the following sheet:
A | B | C 10 | 20 | 30 x | x | - I would like to sum the second row (the one with values) for each column that has the value "x" in the third row. In the example above the sum should be 30 (10+20). How can I do that easily? I have many columns after column C so I can't use a regular IF-function. Very grateful for fast response! Regards, S |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Easy question? Page numbers | Excel Discussion (Misc queries) | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |