sumifs not working, but same formula working else where

[DEEARO]

Hi all,

thank you in adavnce.

I have a sumifs formula which is not working (ROW 161), but i have used the same formula in row (160 and it works).

[AliGW]

Merged cells - sinful!!!

So you'll need to offset the second criterion thus:

=SUMIFS(D$33:D$83,$C$33:$C$83,$C$161,$B$32:$B$82,$B$4)

[DEEARO]

Hi Ali thank you very much, it has worked How how was the formula worked in row 160

[AliGW]

Because of alignment. The values don't actually exist in the rows you are referencing in the row 161 formula, so you need to offset to make it reference the FIRST cell in the merged cell.

Don't use merged cells - just copy down values to individual rows, and then you won't have issues like this.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[AliGW]

Thanks for the rep.