Forum Discussion
sumifs errors
I am using the following formula to match data from two different spreadsheets. This works for the individual row but I need to do around a thousand rows. When I hit the + to copy down to the remai...
Which column contains the formulas?
Is it correct that column H features both as sum range and as one of the criteria ranges?
No column T carries the formula. Here is the Example
C E F H J L n
| 231-5026439-4 | 1 | MY | 6000 | 660 | $ 660.00 | 34.98 | 1.25000000 | 6000 | 0 | TRUE |
| 231-5026439-4 | 2 | PH | 9 | 453 | $ 453.00 | 0 | 2.25000000 | 9 | 0 | TRUE |
| 231-5026439-4 | 3 | CN | 6000 | 1176 | $ 1,176.00 | 323.4 | 3.25000000 | 6000 | 0 | TRUE |
| 231-5026439-4 | 4 | CN | 3 | 320 | $ 320.00 | 80 | 4.25000000 | 3 | 0 | TRUE |
| 231-5026439-4 | 5 | PH | 249 | 32783 | $ 32,783.00 | 0 | 5.25000000 | 249 | 0 | TRUE |
| 231-5026439-4 | 6 | CN | 2 | 124 | $ 124.00 | 31 | 6.25000000 | 2 | 0 | TRUE |
| 231-5026439-4 | 7 | MY | 200 | 80962 | $ 80,962.00 | 0 | 7.25000000 | 0 | -200 | FALSE |
| 231-5026439-4 | 8 | CN | 2070 | 5664 | $ 5,664.00 | 1416 | 8.25000000 | 0 | -2070 | FALSE |
| 231-5026439-4 | 9 | CN | 110 | 117 | $ 117.00 | 29.25 | 9.25000000 | 0 | -110 | FALSE |
| 231-5026439-4 | 10 | CN | 55 | 11 | $ 11.00 | 2.75 | 10.25000000 | 0 | -55 | FALSE |
| 231-5026439-4 | 11 | CN | 500 | 213 | $ 213.00 | 53.25 | 11.25000000 | 110 | -390 | FALSE |
| 231-5026439-4 | 12 | CN | 4640 | 5287 | $ 5,287.00 | 1321.75 | 12.25000000 | 55 | -4585 | FALSE |