ok, I am using sumif to add columns with particular names next to them, but I
am selecting the names from a dropdown list

A1 B1 C1 D1 E1 F1
amount Name Reason (selectN) (selectR) £
£24 smith 56 X X =?

So I'm using Sumif to total all of "smiths" Sales in one cell, but I want to
Add all of his sales for one reason code
is there a way to use sumif with more than one criterion?