Summing a range if cell in another range contains string

[Caugello]

I am trying to create report of the in and outs of tools we are shipping for repair.

Currently in Tab 1

Column F - Date shipped for repair
Column G- Vendor Name
Column H- Date Returned

What I need in Tab B

Vandor - Total Sent- In Repair @ Vendor- Total Repaired - Total Unrepaired


Here are Images if it makes it a little easier to understand


The Info I currently have
image1.png

The info I required filled out based on the previous data
image2.png

Any help is greatly appriciated.
Many thanks

[p24leclerc]

I can't see how you'er going to deduce the "total unrepaired" with the data you have.

[FDibbins]

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[p24leclerc]

Look at the attached workbook for a working report.
FDibbins is right though, you have better chance to receive answers if you post a sample workbook.

[Caugello]

First thank you very much for your help so far. Also, my apologies first timer here will make sure not to post images next time. So in order to count the unrepairable it would be best to have another coloumn for unrepaired date returned correct?

[p24leclerc]

I do think so. It can't be done with your actual data.

[Caugello]

It worked. I inserted a new coloumn for the dates the Unrepaired are returned and it's all working fine. Thank you p24leclerc for your help, it is greatly appriciated.