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.

 

[Fluff]

I just changed the name of the module to "abc" & then in the sheet pressed F9 & all the #NAME? disappeared.

 

[jeffdolton]

I just changed the name of the module to "abc" & then in the sheet pressed F9 & all the #NAME? disappeared.

I have just tried that. The #NAME? disappeared but the amounts aren't showing the the cell on the Summary tab.

 

[jeffdolton]

I have just tried that. The #NAME? disappeared but the amounts aren't showing the the cell on the Summary tab.

Just one other thing please, I've deleted some products in the Receipts tab but the functions on the summary tab do not update. When I start using this programme in the future I will need to amend the figures on the Receipts tab.

 

[Fluff]

I'll leave that to @maabadi as it's his/her code.

 

[maabadi]

@jeffdolton Please
You should Copy Function at Macro window, Insert New module and Paste code there. then delete Previous module. Save file and formula working.

If not, I upload your modified file here again.

 

[Fluff]

You should Copy Function at Macro window, Insert New module and Paste code there. then delete Previous module. Save file and formula working.

There is no need to do this, just changing the name of the module is sufficient.

 

[jeffdolton]

There is no need to do this, just changing the name of the module is sufficient.

I have inserted a new module and copied over the function code then deleted the old functiony
Loaded in new data to the Receipts Output tab
Run the three macros

All calculations are showing as 0.
By pressing F2 then enter on each function provide the correct result.

Perhaps you could send me the file please.

 

[maabadi]

In the file you uploaded At column Q , You have only Kitchen, Free & Boat Hire then if your first criteria was others, formula show Zero.

SumifFile

 

[jeffdolton]

In the file you uploaded At column Q , You have only Kitchen, Free & Boat Hire then if your first criteria was others, formula show Zero.

SumifFile

Thanks, I was aware of that. Maybe its a stupid question but how do I copy the file you've uploaded to excel proper?

 

[maabadi]

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).