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: 2
Default Count rows with criteria from two columns?

Using Excel 2007 under XP Pro SP3.

I'm new to Excel and spreadsheets in general, so maybe this belongs
under excel.newusers, but a google search didn't show anything that
looked right.

I have two columns of alpha data, each cell can contain "A", "B" or be
blank.

I need formulas to count

1. In how many rows are either or both cells non-blank.
2. In how many rows does either or both cells have the value "A"

--
Bert Hyman St. Paul, MN
 
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 criteria from two different columns ba374 Excel Discussion (Misc queries) 2 November 13th 07 04:41 PM
Count where criteria in 2 columns are met [email protected][_2_] Excel Discussion (Misc queries) 9 September 14th 07 12:04 AM
Need to count based on different criteria in two columns Adlin Excel Worksheet Functions 3 May 25th 07 08:05 PM
count rows that meet two criteria in two different columns? dsk3808 Excel Worksheet Functions 6 June 28th 06 09:18 PM
Count Rows with two criteria Eli Waite Excel Worksheet Functions 3 March 8th 05 10:38 PM


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