donnajay314
New Member
- Joined
- Apr 29, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
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
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