tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
need a formula for this one
I have a large range of data in columns AU:HI
many of the cells are empty, but what i'm trying to count is always only data in a cell
so what i need is a formula to do these two things
count the number of time the word "sold" comes up in the range above,
but it can only count rows that have the word "Drawn" in Column A
is this posible?
thanks
Tony
need a formula for this one
I have a large range of data in columns AU:HI
many of the cells are empty, but what i'm trying to count is always only data in a cell
so what i need is a formula to do these two things
count the number of time the word "sold" comes up in the range above,
but it can only count rows that have the word "Drawn" in Column A
is this posible?
thanks
Tony