Forum Discussion
Formula help VLOOKUP? MATCH? INDEX>
Hi There, I've completed a data query and have a long list in Sheet A with three columns: Column A are dates Column B are the same 5 items repeated every five rows, let's say Revenues CoGS Payr...
In B2 on Sheet B:
=SUMIFS('Sheet A'!$C$2:$C$21,'Sheet A'!$A$2:$A$21,B$1,'Sheet A'!$B$2:$B$21,$A2)
Change Sheet A to the actual name of the first sheet, and adjust the ranges as needed.
Fill to the right, then down, or vice versa.
HansVogelaar so simple! Thank you. Someone kept telling me to use VLOOKUP and I was struggling.