#### donnajay314

##### New Member
I tried searching this but I am not sure what I am exactly asking for.

I have this formula =SUMPRODUCT((D\$6:D\$36>=209999.95)*(D\$6:D\$36<=219999.94)) see below chart

This formula spans across 12 columns which represent the months of the year,

So the January column has numbers in many different dollar fields, as does February etc.

I am trying to total across my row from Jan to Dec the amount of times in the months that we hit the certain numbers TOTALS

When I do autosum it returns a 0, when I highlight the cells across it returns a 0

I was giving this sheet so I do not have the knowledge behind it.

I have formatted the cells to number, general, cleared the formats.

Any help will be appreciated

Thank you

#### Attachments

• 1621612575643.png
1.1 KB · Views: 3

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

#### jasonb75

##### Well-known Member
Do you have calculation on manual?

I can think of no other reason why that could happen. A simple sum formula such as the one generated by autosum would only ignore the numbers if they were formatted as text. As the numbers are already the product of another formula it would not be possible to have them formatted as text unless there are text functions used in the formula (there are none in the formula showm).

#### donnajay314

##### New Member
Do you have calculation on manual?

I can think of no other reason why that could happen. A simple sum formula such as the one generated by autosum would only ignore the numbers if they were formatted as text. As the numbers are already the product of another formula it would not be possible to have them formatted as text unless there are text functions used in the formula (there are none in the formula showm).
No it is on automatic.

#### donnajay314

##### New Member
Do you have calculation on manual?

I can think of no other reason why that could happen. A simple sum formula such as the one generated by autosum would only ignore the numbers if they were formatted as text. As the numbers are already the product of another formula it would not be possible to have them formatted as text unless there are text functions used in the formula (there are none in the formula showm).
Thank you, I found there was a circular reference on the first cell, I removed it and now it works.

Replies
2
Views
75
Replies
4
Views
92
Replies
1
Views
36
Replies
0
Views
48
Replies
0
Views
85

1,141,608
Messages
5,707,374
Members
421,506
Latest member
TekillaSunrize

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