=countif ???
You would have to use SUMPRODUCT:
=SUMPRODUCT((B:B="lex"),(C:C="Agent")) However, in order to use the B:B or C:C reference I believe you need XL 2007. If you're not using that you need to specify your range, i.e., B1:B10000, etc. Dave -- Brevity is the soul of wit. "Tammy" wrote: Can I specify two columns to pull info from? For example - what is wrong with this formula? COUNTIF('Utilization Detail'!B:B,"lex") AND ('Utilization Detail'!C:C,"Agent") |
All times are GMT +1. The time now is 06:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com