Good afternoon,
I'm trying to create a format or formula that will add a quantity to a Total cell if the date in the cell next to it is less than 90 days, as shown.
Capture.PNG
Good afternoon,
I'm trying to create a format or formula that will add a quantity to a Total cell if the date in the cell next to it is less than 90 days, as shown.
Capture.PNG
Unable to see the pic, can you attach a sample workbook of what result you are trying to achieve?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hope this works.. sample.xlsx
Thanks for the upload
- add a quantity ....what quantity?I'm trying to create a format or formula that will add a quantity to a Total cell if the date in the cell next to it is less than 90 days, as shown.
- to a Total cell ...where is the total cell?
- if the date in the cell next to it is less than 90 days....for that, something like =if(E2>C2+90,do this, do that)
Perhaps include some sample answers for us?
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
Using the sample, I'm trying to create a formula that when the dates (A,C,E,G,I) fall within 90 days of expiration, it will add the qty's next to them (B,D,F,H,J), into column K. In this case A and E meet the criteria, so B and F would be summed to show 4 in column K.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks