I'm currently working with this array formula...
=SUM(IF(G4:BJ4>C4,C4,G4:BJ4))*0.09615
How do i change this so that G4:BJ4 refers to every 5th cell staring with
G4.
Ie G4, L4, Q4, V4 ......etc.
CHeers
steve
I'm currently working with this array formula...
=SUM(IF(G4:BJ4>C4,C4,G4:BJ4))*0.09615
How do i change this so that G4:BJ4 refers to every 5th cell staring with
G4.
Ie G4, L4, Q4, V4 ......etc.
CHeers
steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks