LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Counting Multiple Text Cells

I am trying to determine the formula to count - only if the criteria in two
(or more) cells is true.

Example Data Set

Service Equipment
Data ATM
Voice DMS 250
Voice DMS 300
Data FR
Voice DMS 250

So i am looking for something to show how often both the serivce and the
equipment criteria meet the desired output.

I tried writing a formula like =COUNTIF(A2:A6,"Voice")AND(B2:B6,"DMS250")

where it would then count the data set and report the value of 2 ... 2 times
the criteria is both voice and dms250.

Any thoughts???

Thanks
 
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
counting text same cell multiple worksheets Robin Excel Discussion (Misc queries) 12 July 22nd 15 02:12 PM
Counting multiple cells containing text. bSB Excel Worksheet Functions 1 June 26th 08 06:28 AM
counting text across multiple columns WastingTime Excel Worksheet Functions 3 November 12th 07 06:04 PM
Counting text in multiple cells. Phil Jenkins Excel Worksheet Functions 8 March 31st 06 04:18 PM
Counting Occurrence of Text within Text in Cells in Range. Jeremy N. Excel Worksheet Functions 1 September 8th 05 05:16 AM


All times are GMT +1. The time now is 12:48 PM.

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

About Us

"It's about Microsoft Excel"