Hi there,
I'm hoping someone can help me please.
This formula:
=SUMIF($AM:$AM,"*May*",$I:$I)
I want *May* to auto change to the next month (June). The cell range (column I) has many month references to different rows.
Thanks
Shane
Hi there,
I'm hoping someone can help me please.
This formula:
=SUMIF($AM:$AM,"*May*",$I:$I)
I want *May* to auto change to the next month (June). The cell range (column I) has many month references to different rows.
Thanks
Shane
In an adjacent cell to the formula, you could enter "May", then drag that field down so the next month would appear. Then, update your formula to refer to that "May" cell and copy the formula down.
After that, hide the column with the month names if you don't want it to be visible.
Does this help?
If you wanna auto change *May* this part
you will have to give cell reference
Try
=SUMIF($AM:$AM,$A1$,$I:$I) highlighted part is month criteria which is situated at A1 cell now when you put June in A1 cell Sumif function will work for June.
Hope this will help you
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
If you are looking to use the current month name, try this...
=SUMIF($AM:$AM,TEXT(TODAY(),"mmm"),$I:$I)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks