I am looking for a formula to get the sum of protein column for individual recipes. Need some help.
You may try:
=sumif(scan(,J:J,lambda(a,c,if(cell("prefix",c)<>"",c,a))),"Veggie Omlette",N:N)