Ms Excel 2010 Importing Data in One ROW and getting sum particular CELL
- by Omeshanker
I am importing data by using .txt file to MS Excel and whole data is imported in ONE ROW. I want to get SUM of those values which corresponds to a particular Month. For Example :-
Name Month Total Value
Mark Jan 2000
Mark Jan 1500
Mark Feb 2900
Mark Feb 3000
I want to get the TOTAL value in the Month Jan in a particular Cell.…