Need help creating a formula

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a worksheet that I am using to track data in until
we get our database developed.

In the meantime I have column H used to track personnel
assigned to tasks using their initials and column E which
has is formatted for date values.

I would like to write a formula that selects all rows in
column H that a person's initials and counts the number
of times that column E is NULL. Would also like to know
how to write a formula with same criteria except where
column E is NOT NULL.

All help is appreciated and I do not have any programming
experience other than using SQL in Crystal Reports. I do
not have access to Crystal Reports with my current
company.

Thanks,
DSM
 
Do you mean it looks for a person's initials, and counts the number of
times a date is there (or simply something exists in the date column)?

If so a simple sumproduct will work, like
sumproduct((H1:H50="Initialsyouwant")*(E1:E50="")) for "null"

and

sumproduct((H1:H50="Initialsyouwant")*(E1:E50<>"")) for "not null"
 
Try COUNTIF

- Sequoia

-------
note: e.mail above is closed due to excessive spam/viruses
resulting from posting it to this forum previously.

if you wish to e.mail me
sequoia UNDERSCORE s AT yahoo DOT com
humans can figure that out ... spambots should choke on it.
 
Thanks Dave...it's nice to see us Dave's sticking
together!!
-----Original Message-----
Do you mean it looks for a person's initials, and counts the number of
times a date is there (or simply something exists in the date column)?

If so a simple sumproduct will work, like
sumproduct((H1:H50="Initialsyouwant")*(E1:E50="")) for "null"

and

sumproduct((H1:H50="Initialsyouwant")*(E1:E50<>""))
Click to expand...
for "not null"
 
Back
Top