The words contained in this file might help you see if this file matches what you are looking for:
...Sumifs and sumif topics ex add w condition criteria greater than or equal to less not if sum range are same saves typing comparative operator in cell including all contains partial text match fuzzy any customer with exactly characters typed directly into formula often times this is inefficient copied down a column across rows whole table between two numbers lower included upper dates inclusive cells corresponding empty corr null string when there wildcard as character use tell look for case sensitive exact inside sumproduct that looks different sheet can t handle d references from multiple columns sheets using indirect functions reference on each will read external the workbook closed solutions year mismatched against serial month only volatile more criterion what we learn video applicable countifs countif averageifs so uses must be met number added faster calculating dsum equivalents unlike formulas update instantly data changes pivottables don date region salesrep product cogs sales ...