Sumproduct Name and Date criteria

Hello guys,

i need help calculatin how much money has been paid for a specific transport company for a certain month.

For example sum the last columnt if the first column equals Schenker and the date is in January.

 

Company Date  price 
Schenker 1.1.2018    500 €
KN 1.2.2018    600 €
DHL 1.3.2018    400 €

Thank you

By: Georgi Kostadinov

Leave a Reply

Your email address will not be published. Required fields are marked *