Got something to say or just want fewer pesky ads? Join us... 😊

Search results

  1. KZNSeagull

    Excel formula help please.

    Wickes is an example. Yes, you would have to have one formula for each supplier, giving you one total per supplier which is what the OP wants.
  2. KZNSeagull

    Excel formula help please.

    SUMIF =SUMIF(A1:A999, "Wickes", B1:B999) Column A has your company names, column B the amounts. No matter how many you add onto the list later, the function will still work (up to 999 rows obviously)
Albion and Premier League latest from Sky Sports


Top
Link Here