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.

 

[maabadi]

Hi. Please Upload file.

 

[jeffdolton]

Hi. Please Upload file.

Hi maabadi. I'm glad you responded as its your code and I didn't want to trouble you any further. Here is the OneDrive link. iZ Test.xlsm

Best regards, Jeff

 

[maabadi]

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

 

[Fluff]

You can just change the name of the module. You should never use the same name for a module & a procedure.

 

[jeffdolton]

You can just change the name of the module. You should never use the same name for a module & a procedure.

Hi, I have done as you suggested but the function didn't update. Here is the link to my further test iZ test2.xlsm
Please see the summary tab - I have highlighted the amounts that should have changed using the data from the Receipts Output tab

 

[jeffdolton]

Hi, I have done as you suggested but the function didn't update. Here is the link to my further test iZ test2.xlsm
Please see the summary tab - I have highlighted the amounts that should have changed using the data from the Receipts Output tab

I pressed F2 on the function cell and the figures updated. Is this what I need to do in future?

 

[Fluff]

If you press F9 it should sort all of them out.

 

[jeffdolton]

If you press F9 it should sort all of them out.

I'll try it again although the auto calc function is on.

 

[jeffdolton]

I'll try it again although the auto calc function is on.

F9 didn't update, only by using F2 on each cell and pressing enter did it work.. That's a shame as I will have to press F2 on every cell I wish to calculate.