Thread: [Solved] Use the > as text in formula
View Single Post
 
Old 10-24-2021, 07:55 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 867
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In the first instance try:
=SUMIF(Object,"*" & D3,$B$3:$B$13)
it means it'll 'ignore' the > symbol, but then it'll just find cells ending in aaa

if that fails then try:
If you have Office 365 try:
=SUM((Object=D3)*(Amount))
otherwise:
=SUMPRODUCT((Object=D3)*(Amount))
Reply With Quote