#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default =countif ???

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=countif question edju Excel Discussion (Misc queries) 5 October 4th 06 11:45 PM
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible? fireofeve Excel Worksheet Functions 4 June 6th 06 02:01 PM
=COUNTIF across Worksheets Trevor Shuttleworth Excel Worksheet Functions 6 December 8th 05 10:58 PM
does the =COUNTIF have to be a range? Xanadude Excel Worksheet Functions 2 April 21st 05 08:31 AM
=COUNTIF How to if 2 or more arguments??? Trixie Excel Worksheet Functions 1 March 3rd 05 07:55 PM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"