| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=countif ???
Right.
-- Brevity is the soul of wit. "Teethless mama" wrote: 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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =countif ??? | Excel Discussion (Misc queries) | |||
| =countif question | Excel Discussion (Misc queries) | |||
| Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible? | Excel Worksheet Functions | |||
| does the =COUNTIF have to be a range? | Excel Worksheet Functions | |||
| =COUNTIF How to if 2 or more arguments??? | Excel Worksheet Functions | |||
Linear Mode
