Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JayUK
  • Order by date
  1. JayUK

    COUNT statement based on 2 criteria

    Hi I am trying to put a formula into a worksheet that will count the number of cells, on a separate worksheet, which meet two criteria - namely place name and type. I have tried the following; =SUM(('Weekly Referrals '!B:B="Barwood")*('Weekly Referrals '!E:E="S")) All I...

Part and Inventory Search

Back
Top Bottom