Excel - Sum of Values based on adjacent list selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beki Goodwin - 24 Apr 2007 22:10 GMT

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!!)

Reply to this Message

Elkar - 24 Apr 2007 23:58 GMT

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

> 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
[quoted text clipped - 3 lines]
> sales, total credit, total cheque. Any suggestions on how to do this (I am a
> novice!!)

Reply to this Message

Rate this thread: