Search results

=SUMIF(A1:A999, "Wickes", B1:B999) Instead of "Wickes" type in a cell ref, eg D4 and then you just type the name of the supplier in D4 and it will come up with the answer. Quicker to find each total. Need to be accurate so possible select from drop down list created on a separate worksheet...