Tim in Toronto
New Member
- Joined
- Nov 18, 2004
- Messages
- 47
Hi All,
I've been scratching my head over this one . . .
- I have 475 Retails stores listed
- These stores are classified & labelled as size "A", "B", "C", "D" or "E" depending on their retail space.
- I have a handful of these stores going through a Grand Opening this Fall 2007
- I would like to draw up a formula that goes through my store size column and count how many times it finds an "A" size store, but ALSO is flagged as "FALL 2007" in the column beside it.
I know the COUNTIF statement will count how many "A" I have listed, but that counts all 111 "A" size stores. Only 9 of those 111 stores are grand opening this Fall.
I are stuck. Help?
Tim
I've been scratching my head over this one . . .
- I have 475 Retails stores listed
- These stores are classified & labelled as size "A", "B", "C", "D" or "E" depending on their retail space.
- I have a handful of these stores going through a Grand Opening this Fall 2007
- I would like to draw up a formula that goes through my store size column and count how many times it finds an "A" size store, but ALSO is flagged as "FALL 2007" in the column beside it.
I know the COUNTIF statement will count how many "A" I have listed, but that counts all 111 "A" size stores. Only 9 of those 111 stores are grand opening this Fall.
I are stuck. Help?
Tim