Excel - Sum of Values based on adjacent list selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a sheet to log sales. One of the columns is a drop down list to
select Cash, Cheque or Credit Card. The adjacent field shows the value paid
by that method. There will be a number of rows of data.

I wish to do a formula at the base of the spreadsheet to show the total cash
sales, total credit, total cheque. Any suggestions on how to do this (I am a
novice!!)
 
The SUMIF function should work for you here:

=SUMIF(A1:A100,"Cash",B1:B100)

This searches for the text string "Cash" in Column A, and if found, adds the
corresponding value from column B. Modify the ranges and criteria to fit
your needs.

HTH,
Elkar
 
Back
Top