Thread: Count rows with criteria from two columns?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bert Hyman Bert Hyman is offline
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
Reply With QuoteReply With Quote