=countif ???
Should be:
=Sumproduct(--(criteria 1),--(criteria 2) or =Sumproduct((criteria 1)*(criteria 2)) It will not work with =Sumproduct((criteria 1),(criteria 2) "Dave F" wrote: 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 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com