OzGrid Free Excel/VBA Help Forum

Thank you very much for this it works perfectly.

also apologies for not replying i know that may appear rude but i had some urgent personal issues which pushed this to the back of my mind.

the help is appreciated

Glad this could fix your problem

Thank you very much for this it works perfectly.

also apologies for not replying i know that may appear rude but i had some urgent personal issues which pushed this to the back of my mind.

the help is appreciated

Hi,

Attached is your test file.

Make sure to check the results ...

Hope this will help

Hi,

Once you have tested the formula ... feel free to share your comments

You haven't said what you actually want as the result if K24 is blank? Perhaps this:

=IF('Analysis-YTD'!$K24="","",SUMIF('Data_Sheet-YTD'!$C:$C,"*"&'Analysis-YTD'!$K24&"*",'Data_Sheet-YTD'!$J:$J))

Hi Carim

Thank you for your quick reply, you really do come to my aid. The reason for the "*" is that The name in K24 is contained within a string the column C:C

For example K24 contains the word Eastbourne and in C:C there could be multiple entries that…

Hello,

When it comes to defining ranges, you should try to restrict to your work area C1:C400 ...

Moreover, your criteria is defined with "*" and this wildcard character covers all possibilities ...

Finally, just make sure Empty is indeed Empty and not…

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…

Glad to hear you have managed to solve your problem.

While performing several tests, your initial shape : Rounded Rectangle 4 has gradually evolved into Rounded Rectangle 13 ....