Forum Discussion
Solved
Xlookup or Index match
Hello, I am needing help with a formula and I just cannot get it quite right. I have tried Xlookup, Index Match, Vlookup and something is just not quite right. I have this first table on a separate w...
See the attached sample workbook.
Hi Tmcgrew05
You seem to run Excel 2021 or 365:
in I4:
=SUMIFS(D3:D15, B3:B15,F4:F10, C3:C15,I3)Corresponding sample attached
Hello Lorenzo
Thank you very much. But how do I copy that down and then on to the next worksheet. So, my workbook contains 31 tabs, one for everyday, a summary tab and then my query tab with the data needed for each days earned value. How do I copy that formula down and then into each day (tab)? Could I use a VBA code to do it for me everyday since my query pulls the data everyday?
See the attached sample workbook.
