# Countif

#### vgoodman

##### New Member
I have created a formula (below) that sums a range based on a date (quarters) in another cell.
=SUMIF(L5:BZ5,">="&A60,L40:BZ40)-SUMIF(L5:BZ5,">="&A61,L40:BZ40)

Additionally, I have a countif formula to get a count in the same period, ie,
=(COUNTIF(L5:BZ5,">="&A60)-COUNTIF(L5:BZ5,">="&A61))

However, now, I have been asked to create a formula that counts based on a date, but also a value. For example, I need to count all the "5's" between January 1, 05 and March 31, 05.

Any thoughts???????

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Code:
``=SUMPRODUCT(--(L5:BZ5<A60),--(L5:BZ5>=A61),--(L6:BZ6=5))``

What does the "--" reference?

Thanks

Replies
3
Views
97
Replies
1
Views
95
Replies
5
Views
212
Replies
6
Views
85
Replies
0
Views
109

1,203,252
Messages
6,054,385
Members
444,721
Latest member
BAFRA77

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