Forum Discussion
Predefined Text in Cells
No worries ituryu
Wyn
MVP
Australia UTC+ 8
If this answer was the best response please click the button
I also happily accept likes
Hello,SergeiBaklan
I have removed it and the formula is now working fine! I truly would loved to keep the custom format on the frame but nothing seems to work except I take out the custom format. Please how do I resolve this and move forward w/ this sheet as I have a deadline.
Thanks and cheers.
Perhaps I misunderstood something. Did you modified SUMIFS? Could you please submit working sample for better understanding.
I see, you removed it from custom formatting and added FRAME to the cells values
Thank you for updating with this info.
As SergeiBaklan pointed out, the use of a number format makes no difference to the cell content.
My use of names requires one to define the Names, something that Bill Bricklin (the inventor of the electronic spreadsheet) described as 'tedious'. Using direct cell referencing, the following works, with or without the custom format:
=SUMIFS($G$4:$G$359,$A$4:$A$359,">="&AE24,$A$4:$A$359,"<="&AF24,$F$4:$F$359,"<>")
No I did not modify the SUMIFS formula, all I did was remove the custom format from the frame column, i.e, the ("FRAME": @ ) I removed and left that section as general!
Also find attached the working sample you requested for.
Thank you so much for the assistance.
Cheers.
