Hello,
I have this file that I have acquired from a previous co-worker. I wanted to manipulate the formula. But i hope the understand what the formula is.
=SUMIF('MISC.'!$L:$L,"="&($A6&TEXT(C$4,"mmm-yy"))
I would like to change the mmm-yy to just Year.
Thank you .
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
=SUMIF('MISC.'!$L:$L,"="&($A6&TEXT(C$4,"yyyy"))=SUMIF('MISC.'!$L:$L,"="&($A6&TEXT(C$4,"mmm-yy"))
I would like to change the mmm-yy to just Year.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Im not sure you need the "=" in there, either...
=SUMIF('MISC.'!$L:$L,$A6&TEXT(C$4,"yyyy")
What this is saying is...
SUM all values in col L that meet the criteria of (whatever is in) A6 and the year in C4 in text format.
However, that does not appear to make any sense...combining A6 and a year in text format will result in a text answer...and you cannot sum text.
Perhaps, as suggested, you provided a sample WB, we could offer better suggestions?
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
Thank you!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks