#### rwmill9716

##### Active Member
I have a list of years in Column A and a list of numbers in Column J. Z5 is a particular year and AA3 is a particular number. My goal is to count the number of times the numbers in J for a particular year exceeds or equals AA3. The following formula doesn't work.

=SUMPRODUCT((\$A\$5:\$A\$20000=\$Z5)*(\$J\$5:\$J\$20000>=AA\$3))

Thanks,

ric

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
I have a list of years in Column A
Are they really years or are they dates custom formatted to display the years?

I created the column of years using the Year() function on a column of dates.

I used this function to solve the problem: =SUMIFS(\$K\$5:\$K\$20000,\$A\$5:\$A\$20000,"="&\$Z6,\$J\$5:\$J\$20000,">="&AA4)

Col K was filled with 1s; Col A years; Cell Z6 a particular year; Col J a list of numbers; Cell AA4 a particular number.

Replies
3
Views
154
Replies
8
Views
413
Replies
8
Views
229
Replies
5
Views
337
Replies
8
Views
340

1,196,254
Messages
6,014,273
Members
441,810
Latest member
LouLou1234

### 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