compare to cells in a row and then move to the next row

[atomicluis]

Hi,

I need a way to compare to cells in a row and then move to the next row.

For example, in the table below I have two rows where ColumnA contains the string "approved" and ColumnB is empty. The count for this should be "2".

There are 3 rows where ColumnA contains the string "in progress" and ColumnB contains the string "completed". The count for this should be "3".

ColumnA ______ColumnB
1 approved
2 in progress__completed
3 approved
4 in progress__completed
5 in progress__completed

My sheet has 50 rows.

Thank you very much!!!!

 

[Peter_SSs]

atomicluis

Not quite sure if this is what you are after, but let's see.

Excel Workbook
	A	B	C	D	E	F
1	Column A	Column B		Column A	Column B	Count
2	approved			approved		2
3	in progress	completed		in progress	Completed	3
4	approved
5	in progress	completed
6	in progress	completed
7
Counting

You might also want to have a look at PivotTables.