Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=countif ???
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 | |||
=countif question | Excel Discussion (Misc queries) | |||
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible? | Excel Worksheet Functions | |||
=countif (h3:h16"=01 01 2006") how to substitute cell for date | 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 |