# COUNTIF with AND...newb question

#### mark gardner

##### Board Regular
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)

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### VoG

##### Legend
Try

=SUMPRODUCT(--(D39:D44=1),--(E39:E44=2))

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,313
Messages
5,836,589
Members
430,438
Latest member
David Gr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back