Dear Team,
previously I have posted similar like this but in total,
since change request to per supplier, need advise which formula can apply to column I4 and J4.
Thank you in advance for you help
Regards,
Wie
Dear Team,
previously I have posted similar like this but in total,
since change request to per supplier, need advise which formula can apply to column I4 and J4.
Thank you in advance for you help
Regards,
Wie
Try
I3Formula:Please Login or Register to view this content.
J3Formula:Please Login or Register to view this content.
Copy down both formula
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)
i have added a table L and M
in I1 , change that to a Date , then you can use that cell as a date range
it can be formatted to just show the month ]i have changed in my example
then you can use SUMIFS() and COUNTIFS() to get the totals
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.
Hi,
Based on your uploaded sample:
In I3 copied down to I5:
Formula:Please Login or Register to view this content.
In J3 copied down to J5:
Formula:Please Login or Register to view this content.
Just keep your SUM formulas for I6 and J6.
See attached.
Thank a lot.
I have learn new formula from above solution.
Have a nice day
You're welcome, thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks