Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- JayUK
- Thread
- Replies: 4
- Forum: -Engineering spreadsheets
