Hi guys!
Need your help: I have data from Row:3 to Row:8318 every row containing years from 2013 to 2017
Row:3 is 2013
Row:4 is 2014
Row:5 is 2015
Row:6 is 2016
Row:7 is 2017
after 2017 above mentioned years repeat. Now i need each year's total (for example sum/total of 2013 and other years).
Hop you understand
Use SUMIF function.
Take a look t SUMIF() for this...
=SUMIF(range with dates, cell with year that you want, range with values to sum)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sample is attached for kind review.
Try this in cell D22. Drag across and down
Formula:
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
if i have data from Row:4 to Row:5933, than what?
got it thank you dear mike7952
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks