I need to sum cells in a range based on the date of the column header. For example, I Need to sum all cells that have apple as the row header and Jan 2015 as the column header.
The formulas I have been trying seem to add all the cells that have apple in the row header. I just want the apple cells for January 2015. I really appreciate any help you can offer.
Thank you!
Do you have your ranges in teh right sequence? Check the formula editing bar and Fx button for assistance
I suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
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
Is Jan 2015 a text entry or is it a date formatted to display as mmm yyyy?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
It is a date formulated as Jan-15
Something like this...
Data Range
The column headers are the 1st of the month dates formatted to display as mmm yyyy.
Cell F1 is also the 1st of the month date formatted to display as mmm yyyy.
This formula entered in H1:
=SUMPRODUCT(--(A2:A10=G1),INDEX(B2:D10,0,MATCH(F1,B1:D1,0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks