jeffdolton
Board Regular
- Joined
- Dec 21, 2020
- Messages
- 100
- Office Version
- 2010
- Platform
- Windows
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.
Any help would be appreciated.