LinkBack URL
About LinkBacks
Thanks all for your prompt assistance!
Return next date and sumif error.
Thanks all for your prompt assistance!
Last edited by kborgers; 11-28-2014 at 11:36 AM.
It looks like you have the wrong quotation marks
”Yes” and it should be "Yes"
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello AlKey - thanks very much, that was exactly the issue! I though I was going mad at one point!
Thanks also to Pepe Le Mokko!
Thanks Olly!! Perfect solution! Many thanks!
In your SUMIF formula, the double quotes around the text Yes are not correct double quotes (no idea what they are). Try retyping them ( I don't get the same cocde for your quotes (138) as for mine (34)). It worked for me after that.
Issue 1:
Your formula criteria isIt should be
”Yes”See the difference?! You are using char 148 ”, instead of char 34 ""Yes"
Issue 2:
Enter this in C3 as an array formula (Ctrl-Shift-Enter):
Formula:
=MIN(IF(E6:E25>TODAY(),E6:E25))
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
You're welcome and thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks