toony
New member
I have added the offset function to the if formula which sums weekly figures. Other than starting from the first day of the week, I want the offset to be the first cell on the day that contains 3 letters “*sub*” which can be in any cell in the week column, but it tells me that I have too many arguments. To be honest I have never used offset before and not sure if there is may be another function that works better to get it to start from the first yes of the week like may be the find function? Much appreciated
=OFFSET(ISNUMBER(SEARCH("sub",E1916),"YES",IF(A1916="","",IF(COUNTIF(A$2:A1916,A1916)=1,SUMIF($A$2:$A$11999,$A1916,S$2:$S12354),"")))
=OFFSET(ISNUMBER(SEARCH("sub",E1916),"YES",IF(A1916="","",IF(COUNTIF(A$2:A1916,A1916)=1,SUMIF($A$2:$A$11999,$A1916,S$2:$S12354),"")))