This also worked very well, thank you for your help.

" wrote:

Because you want it to evaluate more than one row of data - try it as
an array formula

=sum(if(user="Adam",if(item="Lunch",Debit,0)))

entered as ctrl shift enter to make it an array formula