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: 3
Default Count instances based on two criteria

I am building a testing log.
Col A contains the test number (values 1-4).
Col D contains the test result codes (values 1-11).

I can count how many results were from test 1 and I can count how many
result codes were 1, 2, 3, etc. using countif().

I am trying to count how many of each result occured in each test. For test
pass 1 how may results were code 1, code 2, etc.

Thanks,
Stuart

 
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
COUNT based on 2 criteria [email protected] Excel Worksheet Functions 14 March 25th 08 12:40 PM
Count based on criteria ba374 Excel Discussion (Misc queries) 1 December 20th 07 11:19 PM
Count based on multiple criteria JerryS Excel Worksheet Functions 1 October 9th 07 06:37 PM
count unique instances based on two columns [email protected] Excel Worksheet Functions 9 May 27th 07 01:49 AM
Count or Sum based on more than 1 criteria Andrew C Excel Worksheet Functions 1 December 29th 05 09:46 PM


All times are GMT +1. The time now is 10:15 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"