Row Count With Matching Cell Criteria
- From: "Lankchevy" <darrelll@xxxxxxxxxxxx>
- Date: 6 Nov 2005 11:41:39 -0800
I need a formula that will count the number of rows (or times) in which
a cell has a date and the other has a certain tank number list. For
example the list in column A has tank numbers like the following:
6-125-4-V
6-120-5-J
8-14-2-V
6-12-3-F
8-12-2-J
In column D, most of the cells are blank until the tank is opened and a
date is entered.
I want to count the number of J tanks that have a date entered, the
number of V tanks that have a date entered, and etc. The closest I have
gotten is with a sumproduct formula but I can't figure out how to match
the certain tank letters with each date entered.
I tried some of this, but none is working:
=SUMPRODUCT((RIGHT(A9:A1611,2)="-J")*(M9:M1611<>""))
=SUMPRODUCT((A9:A1611="-J")*(M9:M1611<>""))
=SUMPRODUCT(ISTEXT(FIND("J",A9:A1611))*(M9:M1611<>""))
=SUMPRODUCT(COUNTIF(A9:A1611,"*-J*")*(M9:M1611<>""))
Any assistance would be greatly appreciated.
.
- Follow-Ups:
- Re: Row Count With Matching Cell Criteria
- From: Bob Phillips
- Re: Row Count With Matching Cell Criteria
- From: Ragdyer
- Re: Row Count With Matching Cell Criteria
- Prev by Date: Re: If statement - simple problems
- Next by Date: Re: How on earth..............??
- Previous by thread: Duplicate files open from autorecover
- Next by thread: Re: Row Count With Matching Cell Criteria
- Index(es):
Relevant Pages
|
