Sumifs

[timedge]

Workbook has two worksheets, "Contractor Names and ID code" and list of all contracts with requirements i.e. type of contracts = "A, B, C or Blank", schedule dates and other items on second worksheet label "Contracts". On the first worksheet need to have the number of type contracts each contractors has. How many A, B, C and Blanks.
Thanks in advance
timedge

 

[Special-K99]

Re: Need help with Sumifs

Unclear, can you supply some example data.

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html