Dear Friends,
I create summary data and the issue is they used different format.
Need advise SUM or SUMIF formula needed. Thank you in advance for your help
Regards,
Wie
Dear Friends,
I create summary data and the issue is they used different format.
Need advise SUM or SUMIF formula needed. Thank you in advance for your help
Regards,
Wie
Last edited by AliGW; 06-02-2020 at 11:41 PM.
Administrative Note:
The title you chose was causing a database error, so I have fixed it for you. However, it was a very poor title, so below is a reminder of what we expect.
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional.)
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.
Dear Friends,
I create summary data and the issue is they used different format and type
Need advise SUM or SUMIF formula needed. Thank you in advance for your help
Regards,
Wie
This cannot be done with either SUM or SUMIF, which is why your original title was so poor. Don't assume you know what functions should be used: just explain what you are trying to achieve and then leave thee choice of function to those helping you.
=SUMPRODUCT((Plan!$B$2:$B$10=LEFT(A2,FIND("-",A2)-1))*(Plan!$C$1:$N$1=MID(A2,FIND("-",A2)+1,2)),Plan!$C$2:$N$10)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
or can try below formula
=SUMPRODUCT((Plan!$C$2:$N$10)*(Plan!$B$2:$B$10&"-"&Plan!$C$1:$N$1=$A2))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Dear All,
Thanks for your advise but I forgot to put PO NO. I need total quantity model with same PO NO.
Here I attached new file. Thank you in advance for your help.
Regards,
Wie
=SUMPRODUCT((Plan!$C$2:$N$10)*(Plan!$B$2:$B$10&"-"&Plan!$C$1:$N$1=$B2)*(Plan!$A$2:$A$10=A2))
try it
So you just need to add the extra criterion:
=SUMPRODUCT((Plan!$A$2:$A$10=A2)*(Plan!$B$2:$B$10=LEFT(B2,FIND("-",B2)-1))*(Plan!$C$1:$N$1=MID(B2,FIND("-",B2)+1,2)),Plan!$C$2:$N$10)
Hi Ali,
That is great. thanks for your help and advise.
Thank to for Ravi.
Regards,
Wie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks