How to Combine SUMIF and VLOOK…
https://www.exceldemy.com/sumif-and-vlookup/
Use VLOOKUP Function to Sum All Matches with VLOOKUP in Excel (For Older Versions of Excel) In this formula, the VLOOKUP function works as the second argument (Criteria) of the SUMIF function. The VLOOKUP function looks for the name Alex in the lookup array (F5:G11) and returns the ID number for Alex. =D5&COUNTIF ($D$5:D5,D5) ⧪ Note: Here D5 is the first cell of the lookup array ( Author ). You use the one from your data set. ⧪ Step 2: ...
In this formula, the VLOOKUP function works as the second argument (Criteria) of the SUMIF function.
The VLOOKUP function looks for the name Alex in the lookup array (F5:G11) and returns the ID number for Alex.
=D5&COUNTIF ($D$5:D5,D5)
⧪ Note: Here D5 is the first cell of the lookup array ( Author ). You use the one from your data set. ⧪ Step 2: ...
DA: 37 PA: 48 MOZ Rank: 86