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… that would allow me to return a summary with the unique Part # and annual sales tallied?
Thanks in advance.
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… that would allow me to return a summary with the unique Part # and annual sales tallied?
Thanks in advance.
2 Replies
=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.
Perhaps PivotTable or SUMIFS() could work. Perhaps you may share small sample file to illustrate how data is structured.
