Count rows with criteria from two columns?

B

Bert Hyman

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
Count Blank Cells with Conditions 3
Count Non-Empty Cells In Each Row 0
Counting NON-Blank fields 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Comparing data from two columns 2
how to count#cells w/= value in other column and not count blank c 5
How to count merged cells 2

Top