Good evening all
I'm new here and not particularly confident with excel, so looking for some guidance!
I'm looking for a formula which will sum 52 rows containing data from a specified point ie ignoring any blank cells
I'm using the OFFSET function but it includes any blank cells
Can the following formula be modified to only include cells with a value?
=SUM(OFFSET(E5,0,0,52))
Any help greatly appreciated
Bookmarks