mark gardner
Board Regular
- Joined
- Sep 6, 2006
- Messages
- 58
probably a dumb newb question...I have 2 columns of data in D and E. Column D has a 1 or a zero in it. Colums E has a 2 or a three in it. I am trying to use a countif formula to dertermine how many rows have a 1 in column D and a 2 in column E. My formula (below) is wrong and I can't figure out how to fix it. Thanks in advance...
=COUNTIF(D39:D44,1)*AND(E39:E44,2)
=COUNTIF(D39:D44,1)*AND(E39:E44,2)