Forum Discussion

Cass_M's avatar
Cass_M
Copper Contributor
May 08, 2019
Solved

IF Function - May be a diff function

Hi all, 

 

I run a sports canteen and I am looking to have 1 sheet for all receipts. My query is:

 

Col A Suppliers Names (Woolworths, Coles etc...)

Col B Receipt Amount

I want to have a formula on my Summary sheet where all "Woolworths" receipts will total, same goes with all other Suppliers. I can do this manually, but I was hoping there was a way I could do maybe an IF(Cell Range="woolworths" then the 'receipt amount' would tally)

 

Any advice would be great, thank you

 

 

excel
Formulas and Functions
training
  • Wyn Hopkins's avatar
    Wyn Hopkins
    May 08, 2019
    Sure, SUMIFS sums up a range of cells based on another range of cells

    So you are summing Column B based on the values in column A = "woolworths"

8 Replies

    • Cass_M's avatar
      Cass_M
      Copper Contributor
      May 08, 2019

      Wyn Hopkins 

       

      Wow that was quick, thank you. do you mind explaining it to me please.

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        May 08, 2019
        Sure, SUMIFS sums up a range of cells based on another range of cells

        So you are summing Column B based on the values in column A = "woolworths"

Resources