drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and Thanks in advance
I am using Excel 2010 for this job.
I would like a Formula to count How many times a Value in Columns B, (Header AAA) and Column C (Header CCC) <> FISH do we have but:
If I do this manually I will Get 6 (D2), (Check Yellow Cells)
I would lke to have a formula in B4 (Does not matter)
For This Query I am not using a Table, but I do not care if a have to use a Table if necessary
Column C (Header Manually) and Column E (Header AAA& BBB) is just to make it easier to understand my need
I am using Excel 2010 for this job.
I would like a Formula to count How many times a Value in Columns B, (Header AAA) and Column C (Header CCC) <> FISH do we have but:
Row 10 and 11 should be 1 (NOT 2)
Row 18 and 19 should be 1 (NOT 2)
Same for Row 22 and 23
If I do this manually I will Get 6 (D2), (Check Yellow Cells)
I would lke to have a formula in B4 (Does not matter)
For This Query I am not using a Table, but I do not care if a have to use a Table if necessary
Column C (Header Manually) and Column E (Header AAA& BBB) is just to make it easier to understand my need