OzGrid Free Excel/VBA Help Forum
The best online resource for all your Excel & VBA requirements
Recent Activities
-
Carim
Reacted withReaction (Post)to Shezmo1’s post in the thread Count values on a row that are within, equal to or greater than a value in row within the same column.
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 -
Carim
PostGlad this could fix your problem -
Shezmo1
PostThank 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 -
Shezmo1
Reacted withReaction (Post)to Carim’s post in the thread Count values on a row that are within, equal to or greater than a value in row within the same column.
Hi,
Attached is your test file.
Make sure to check the results ...
Hope this will help -
Shezmo1
Reacted withReaction (Post)to Carim’s post in the thread Count values on a row that are within, equal to or greater than a value in row within the same column.
Hi,
Once you have tested the formula ... feel free to share your comments -
rory
Replied to the thread Formula summing up even if the reference cell is empty.PostYou 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)) -
DezB
Replied to the thread Formula summing up even if the reference cell is empty.PostHi 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… -
Carim
Replied to the thread Formula summing up even if the reference cell is empty.PostHello,
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… -
DezB
Posted the thread Formula summing up even if the reference cell is empty.ThreadHi 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… -
Carim
Replied to the thread Hide Shape unless cell holds specific text value.PostGlad 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 ....