kmlynn1010
Board Regular
- Joined
- Feb 8, 2005
- Messages
- 95
Hello friends!
I can't figure out why this isn't working.
=SUMPRODUCT($N$9:$N$88<"10/1/04")*($E$9:$E$88="J Doe")
where I want it to count 1 and sum if the N cell is > 10/1/04 and the E cell has in it J Doe. When tested it doesn't pick it up. Does it have to do with the date? I've also tried to reference a cell in place of "10/1/04" but still no progress.
Any help is much appreciated!
I can't figure out why this isn't working.
=SUMPRODUCT($N$9:$N$88<"10/1/04")*($E$9:$E$88="J Doe")
where I want it to count 1 and sum if the N cell is > 10/1/04 and the E cell has in it J Doe. When tested it doesn't pick it up. Does it have to do with the date? I've also tried to reference a cell in place of "10/1/04" but still no progress.
Any help is much appreciated!