# Sum Product and Count IF . is this possible?

#### Raj1313

##### Board Regular
HI I have the below formula working fine :

=SUMPRODUCT((MONTH(A:A=\$C\$64)*1)) - This finds all entries which are December in a list of dates.

I want to add a count IF to it which is =COUNTIF(A:A,D57) - is this possible?

Last edited:

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### steve the fish

##### Well-known Member
Unless the D57 has a date in December it will produce 0 or if in December the countif can be used on its own from what I can see. You are testing the same range with both formulae.

##### MrExcel MVP
What do you have in C64 and in D57 exactly and what do you mean by adding?

#### Raj1313

##### Board Regular
C64 relates to December and D57 is just text. I need the formula to find all the text (D57) from column (B;B) MTD and also only include records MTD from the date column (A:A). if that makes sense

#### steve the fish

##### Well-known Member
C64 relates to December? What does that mean? What is in cell C64 exactly?

#### Raj1313

##### Board Regular
C64 is "December" the month n a date format of MMM

#### steve the fish

##### Well-known Member
What appears in the formula bar? We need the cell value not its appearance after formatting. MMM should produce Dec not December.

#### Raj1313

##### Board Regular
The Cell Value is =Today() which produces December after formatting it to mmmm

Last edited:

#### steve the fish

##### Well-known Member
Try:

=COUNTIFS(B:B,D57,A:A,">="&EOMONTH(C64,-1)+1,A:A,"<"&EOMONTH(C64,0)+1)

Replies
2
Views
285
Replies
3
Views
499
Replies
3
Views
289
Replies
7
Views
149
Replies
5
Views
1K

1,190,764
Messages
5,982,797
Members
439,798
Latest member
tangojuliet

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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