# counting cells from multiple columns within a specific date range

#### qctech

##### New Member
Hello All,

As stated above, I'm trying to count several columns of information within a specific date range. So far I have this:

=IF('CODE ISSUES'!A=DATE(2014,1,1),COUNTIF('CODE ISSUES'!J:N,A3))

What I'd like to do is graph information on a monthly basis. Hope this makes sense.

Thanks,
qctech

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### Rijnsent

##### Well-known Member
Hi qctech,
a small sample of your data might help, as a table tells more then a thousand words.
But basically what you want is:
-if column A is from jan 1st to jan 31rd, count the amount of cells in columns J-N that are equal to cell A3?
Assuming you use Excel 2007+, I would go for a COUNITFS formula. Something along the lines of: COUNTIFS('CODE ISSUES'!J:N,A3,'CODE ISSUES'!A,">="& DATE(2014,1,1), 'CODE ISSUES'!A, "<"& DATE(2014,2,1))

Hope that helps,

Koen

#### qctech

##### New Member
Hello Koen,

I was finally able to pry the knowledge out of one of our electrical engineers. I'm using a sum array for what I need:

=SUM(
('CODE ISSUES'!\$J\$6:\$N\$6000=A4)*('CODE ISSUES'!\$A\$6:\$A\$6000>\$H\$2)*('CODE ISSUES'!\$A\$6:\$A\$6000<\$H\$3))

Where column A is the date entry, columns J through N are the data to be collected, and H2/H3 is the range of the date entries to collect info from.

Sometimes I think electrical guys have way too much time on their hands.

Louis

Replies
4
Views
225
Replies
1
Views
290
Replies
1
Views
390
Replies
1
Views
196
Replies
1
Views
288

1,195,923
Messages
6,012,314
Members
441,690
Latest member
CyberWrek

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