Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Needed : Sum on Conditions
Row A B C…….columns
1 FTB YRT STX 2 USA CAN UAE 3 33 66 33 4 STX FTB YRT 5 UAE USA CAN 6 44 88 69 7 YRT STX FTB 8 CAN UAE USA 9 66 77 88 Hi all, I want smallest formula in cell D1 which should show SUM of figures which are in Range("A1:C9") (as shown above) after working out something like this (see below) =SUM(A1:C9="FTB")+(A1:C9="USA)+(A1:C9) In other words I want formula to find "FTB" in given range and then if there is "USA" on row below then sum the figure in row below the "USA". I hope I was able to explain my question. Please can any friend can help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with conditions - urgent help needed | Excel Worksheet Functions | |||
Date Formula with 2 conditions met needed | Excel Discussion (Misc queries) | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Two conditions in one cell. Help needed ASAP | Excel Discussion (Misc queries) | |||
2 conditions needed to check and count of items based on that | Excel Worksheet Functions |