atomicluis
New Member
- Joined
- Nov 9, 2005
- Messages
- 7
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!!!!
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!!!!