| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=countif ???
yes it worked too thanks!
"Dave F" wrote: The ranges need to be the same size. Use C2:C5054. Also, use the first formula you give below. The one I gave you is incorrect. Dave -- Brevity is the soul of wit. "Tammy" wrote: Dear guys - I tried both: =SUMPRODUCT(--('Utilization Detail'!B2:B5054="tul"),--('Utilization Detail'!C2:C5000="Agent")) =SUMPRODUCT(('Utilization Detail'!B2:B5054="tul"),('Utilization Detail'!C2:C5000="Agent")) and both return #Value! errors? Any advice please? "bj" wrote: if you want to count when both criteria are met try =sumproduct(--('Utilization Detail'!B1:B1000="lex"),--('Utilization Detail'!C1:C1000="Agent")) with sumproduct, you can't use the shorthand for entire columns or rows the "--(" changes the true/false logic response to 1/0 numeric. if you want when either are met try =COUNTIF('Utilization Detail'!B:B,"lex") + ('Utilization Detail'!C:C,"Agent") "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 | |||
| Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible? | Excel Worksheet Functions | |||
| use =countif to generate returns from more than one column | Excel Discussion (Misc queries) | |||
| using =COUNTIF to count two text values | 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
