Hello.. Can someone help me write a formula that would brake down the backlog figure down into totals for Due Date ( Total due for April, Total, due for March, etc.).
Screenshot 2024-02-13 103606.png
Hello.. Can someone help me write a formula that would brake down the backlog figure down into totals for Due Date ( Total due for April, Total, due for March, etc.).
Screenshot 2024-02-13 103606.png
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
and while you're at it... explain how you want that strange "02/16 - 05/23" entry handled. It's many things but it's not a date inside a single month...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please forgive me for not following directions. Fudge.
I have attached the test data. The blue highlighted is what I am needing help with.
I did it manually for showing the desired outcome. I was hoping not to have to
do each month manually.
Is there a way. I changed the one with the two ship dates.
Thank you very much for your time and assistances
Sir.
I reposted everything and fixed the two different due dates that were in question. I really do appreciate your time and assistances.
Thank you for sharing you knowledge and understanding of EXCEL.
1. In the BLUE area, delete the trailing spaces. "April " is not the same as "April".
2. I do not believe your expected results. The dates fro some of the values are 2020, others are 2023. Does the YEAR not matter?
This delivers your expected results:
=SUMPRODUCT(--(TEXT($D$4:$D$18,"mmmm")=[@Column2])*$C$4:$C$18)
Sir..
Forgive me. I copied the worksheet from a several worksheet page that was to big to send. When I did that the year changed for some reason.
Forgive me for my ignorance.. what do you mean by delete the trailing spaces.
Trailing spaces. The space after April (red) makes it different from April (green).
"April " is not the same as "April"
It's caused by sloppy data entry.
Oh.. now i see. I am sorry for my sloppy data entry. there is a space after April. Was not aware of that. I will pay closure attention that
data entry. I have been spoiled using accounting software to work with data management. My excel skills are shotty. I am working hard
to improve. THANK YOU
Sir.
I hate bothering you. but I am getting N/A on my formula entry. I typed it just the way you have it.
Can you check my work please?
There is also a space after January. Check them all.
Sir.
Thank you. I got it to work. I was also including data spots that had no information in it causing it to #N/A
THANK YOU THANK YOU THANK YOU
Sir..
I am really sorry for bothering you, but I want to understand the formula as well.. What does the two hyphens mean or do right after =SUMPRODUCT(--(TEXT
Perhaps post #3 of the linked thread will help: https://www.excelforum.com/excel-for...rmulas-do.html
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks