Dear Experts
I have set of data range with number and text values in cell range i want calculate particular column range depends upon header values
I want sum where ever find EAST,WEST,SOUTH,NORTH in header of data range result of sum comes in CALL TOTAL AGING below header column till end of row serial nos ends in A:A...
find the attachment pls help on this
Why not use =D2+F2+H2+J2 in Cell K2?
Why use something complicated?? Is the format ever going to change?
Deep
Cheers!
Deep Dave
Else check the file out.
I'v used Helper Cells.
Let me know if it is ok?
However, I am not totally convinced with my formula..
Deep
Last edited by NeedForExcel; 02-17-2014 at 11:41 AM.
Maybe:
Please Login or Register to view this content.
Thanks sir !!! Its works amazing! solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks