Hi Folks
I have this formula which looks at a cell, then looks for every instance of the name in that cell on another sheet and sums the figures in another column wherever that name occurs. However, if the reference cell is blank, for some reason it then sums everything in the column that contains figures. I don't understand why???
=SUMIF('Data_Sheet-YTD'!$C:$C,"*"&'Analysis-YTD'!$K24&"*",'Data_Sheet-YTD'!$J:$J)
Data_Sheet-YTD C:C contains all the names the name in Analysis-YTD K24 is looking for and Data_Sheet-YTD J:J contains the figures to be summed.
I've tried using and IFERROR addition, no joy...
Any thoughts please??
Kind regards and many thanks..
DezB