Forum Discussion
Look up across multiple rows
Hi My accounting sales summary returns each invoice individually. As a result I have multiple rows with the same part number but different quantities. Is there a combination of Vlookup plus sum etc… ...
=SUMPRODUCT(($B$2:$B$25=G2)*(MONTH($D$2:$D$25)=H2)*$E$2:$E$25)
Maybe with this formula as shown in the attached file.