| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumproduct with different number formats
I am using the following formula to sum rows based on the name in cell
A and the month in row 4. It works until I change my row limit from 54 to 55. In row 55 my number format changes from currency to percentage. I will never need to add the rows with percentages, but will need the formula to be from B6:M200. Any suggestions? (Thanks in advance.) =SUMPRODUCT(('AHB - Actual'!$B$6:$M$54)*('AHB - Actual'!$A$6:$A$54=$A4)*('AHB - Actual'!$B$4:$M$4<=B$2)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
| number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
| How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
| Conditional Number Formats | Excel Discussion (Misc queries) | |||
| number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
Linear Mode
