My apologies Remy et al,
You are correct regarding the earlier post and despite the many
possibilities, this issue still plagues me.
Unfortunately my Internet has been down a week so hence the late reply.
I did try your proposed solution however on further investigation into
the formula
Hi,
I believe you had a similar (if not identical question) which you
posted back on September 27th (topic: IF doesn't respect AND - http://d
ocument-foundation-mail-archive.969070.n3.nabble.com/IF-doesn-t-
respect-AND-td4249584.html). At the time you had uploaded a file to
Google and I had
I'm not sure I follow your logic, but if your source range contains a list
of values that includes nulls, and non-numbers, you need to logically
exclude those from a math statement, or you get the 'VALUE' error (tried to
do math on a non-numeric cell.) ISBLANK, and ISNUMBER are functions that
Hi,
What I need help with is the formula to find any row from Data.$A$3 to
Data$A$1000 and after shortening the 8 digit date value to 6 digit
value, and having the same 6 digit value as Summary.$A4, forward ONLY
those rows onto the next part of the formula i.e. SUMIF.
I have a formula shown