Nick055
Nick055
-
Re: Please help with combined SUMIF, INDEX, and MATCH formula
In words this formula does: COLLECT creates a range of items that match the criteria. In this case we need all the quote amounts on the other sheet IF the week number matches the week number of the r…1 · -
Re: Please help with combined SUMIF, INDEX, and MATCH formula
Oh! I think I see what I did, I got the week# & quote amount references switched up. Try this: =SUM(COLLECT({$ Amount Quoted from Q&S Master Log 2024}, {Quote Submitted Week No from Q&S M…1 ·
