How many orders for ITEM_1 are there after TODAY() from Companies that are supposed to order?
How many orders for ITEM_1 are there after TODAY() from Companies that are supposed to order?
Kindly unlock the sheet so that ranges can be selected.
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
Similar to formula above (E12), just add date criteria:
D E 12How many orders for ITEM_1 should there be? 5 13How many orders for ITEM_1 are there after TODAY() from Companies that are supposed to order? 2
D E 12How many orders for ITEM_1 should there be? =SUM(SUMIFS(B2:B8,$A$2:$A$8,$D$2:$D$11)) 13How many orders for ITEM_1 are there after TODAY() from Companies that are supposed to order? =SUM(SUMIFS(B2:B8,$A$2:$A$8,$D$2:$D$11)*(E2:E11>TODAY()))
Sheet: Sheet3
E13:
Formula:Please Login or Register to view this content.
array formula have to be accept with CSE (as E12).
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Works 100%. Thanks.
Hi,
One way with CSE
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks