Function not working

[jeffdolton]

Hi, I've been given a function from a member of this Forum. By typing =SumIfsEveryNColumns(criteria 1, criteria 2,criteria 3) and inserting the criteria, the function sums every nth column from a specific cell and returns an amount if the criteria is met. This function worked well until I loaded new data. The original cell data containing the function didn't change and when I tried to edit using F2 and pressing enter I get #NAME?. I'm confused as this function has worked before.

Any help would be appreciated.

 

[jeffdolton]

Copy your file to This if You don't have more macro than this file (this file has 4 macro).
Or open Both file , Go to VBA window and drag Macro (At Up-Left window under workbook name see each file sheet and modules) from this file to yours (of course first delete same macro at your file).

I’m sorry, I’ve done everything you’ve suggested but pressing F9 doesn’t update the calculations. I’ll put up with pressing F2 on each calculation, it’s not a bother. I have one more requirement. On the Summary page there are two cells that are called Gift Card Purchases - one Card one Cash. Would you kindly insert an offset function in there so that the cells aren’t affected by inserting columns in Receipts Output. Many thanks.

 

[maabadi]

Sorry. I don't think I can do it.
This is images of How replace new function with Previous. Please Do it Exactly & Step to Step. Then your function should work.

 

[maabadi]

AND one other thing. Press
CTRL+ALT+SHIFT+F9

 

[jeffdolton]

Sorry. I don't think I can do it.
This is images of How replace new function with Previous. Please Do it Exactly & Step to Step. Then your function should work.

Thank you. The procedure was already set-up, however using CTRL+ALT+SHIFT+F9 worked. I had been trying ALT+F9. So that's it for now. Many thanks for all your help, it is much appreciated. I will start another thread regarding the use of OFFSET as this relates to formulae not affected by your code.

 

[maabadi]

You're welcome.