LinkBack URL
About LinkBacks
Hello. If I have dates in the Jan-13 format, how do I do a sumif referring to those dates for a specific year? Thanks.
Hello. If I have dates in the Jan-13 format, how do I do a sumif referring to those dates for a specific year? Thanks.
Which column contains the dates, and which column do you want to sum?
Pete
Row 1 contains the dates. I want to sum row 2.
this seems very much related to this thread of yours?
http://www.excelforum.com/excel-gene...arly-sums.html
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
Try this formula, then:Originally Posted by amartino44
=SUMPRODUCT(--(YEAR($1:$1)=2013),$2:$2)
Hope this helps.
Pete
unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks