Thread: [Solved] Use the > as text in formula
View Single Post
 
Old 10-24-2021, 02:26 PM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Thank you both. The SUMPRODUCT works but I chose the simplest code,
=SUM((Object=[@Object])*(Amount))
Reply With Quote