Mar 15, 2024 · 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 …

Oct 14, 2021 · Hi I need to combine an index match match to sum the cells when multiple results are found. I'm struggling to incorporate the SUMIF / SUMIFS, if someone could please help? …

Oct 27, 2012 · Worksheet A Worksheet B Hi, I am asking for assistance putting together a formula that can: 1. Search WS-A's A Column for current date and Match the User in Row 1 with …

Nov 11, 2005 · I can make my formula work (B16) with SUMIFS, but because the columns may change in time (Labor in column C, could someday be in column E), I would prefer to grab a …

Oct 8, 2009 · Hi, have you read the article on that site about the difference between VLOOKUP, SUMIF (S), and INDEX/MATCH ? They are not completely interchangeable. There are some …

Feb 3, 2020 · Hi, I'm trying to return the sum of all the amounts under the Source "INAP Ubersmith" for the month of January. As you can see in this screenshot, The source criteria is …

Mar 9, 2021 · I'm failing to come up with a SUMIF INDEX MATCH formula. I want to MATCH a name in Column P to Column B and SUM up the two totaled cells in Column L to go in Column …

Aug 28, 2015 · I'm trying to do a sumifs or sumproduct with multiple criteria. I have lookups both vertically and horizontally and want the sum of the number that matches all criteria. If I needed …

May 9, 2025 · I tried an Index and an Index/Match, instead of Sumifs, but my formula was incorrect. INDEX/MATCH finds a data point. A single cell. SUMIF and SUMIFS evaluates an …

Apr 10, 2020 · Hello, I'm having a difficult time writing a formula that acts like Index match match along with sumifs. I have a table with a column of dates and 4 columns with names. To the …