Summing Mixed Text and Number Column

Paul Newcome

When I went back to copy/paste your formula to make a change I noticed that @cell is in all caps @CELL. This needs to be all lowercase. Try fixing that first. If that doesn't work then try the below formula. If that doesn't work either then I will need to throw some mock data in a sheet to do some testing.

=SUMIFS([Amount]:[Amount], [Purchase Coding]:[Purchase Coding], FIND("241", @cell) > 0)

Cristina Andersen

Oh goodness! Lowercase @cell worked! Thank you SOOOOO much!

Paul Newcome

Happy to help. 👍️