excel help.JPG
Hi Friends,
I require a small help regarding IF function in Excel.
If you see in the above table, there are 5 columns A,B,C,D,E.
Rows 101 - 108 contains various input values & Rows 110 - 113 is where outputs should be displayed.
Now all I require is an addition operation to be performed at D110 & E110 where, in the 110th row, corresponding to London, all the values in column D, having London in column C should be added and the output is to be displayed at D110.
Likewise for the output cell of E110 where all the values of the column E having London in their corresponding column C should be added and the result is to be displayed at E110 cell.
I tried all the available functions, but could not do so. Normally in case of 100 rows or columns, I can do it manually, but when faced with 1000's of rows and columns, its very difficult to manually select all those cells to perform any arithmetic operations.
So I require your valuable suggestions and advices.
Thank You in advance.
Bookmarks