uhhhhhhhhben
New Member
- Joined
- Feb 3, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
I'm trying to average the data from every 4th column between the ranges C4:AY4
I've tried using the formula {=AVERAGE(IF(MOD(C4:AY4),4)=3, IF(...) } but I can't seem to figure out how to complete the last bit of the formula
Any solutions would be great even if it doesn't use that formula. Thanks
I've tried using the formula {=AVERAGE(IF(MOD(C4:AY4),4)=3, IF(...) } but I can't seem to figure out how to complete the last bit of the formula
Any solutions would be great even if it doesn't use that formula. Thanks