Excel Subtoal

[Amanda Beaumont]

I'm an ASB advisor for my school and we are selling Homecoming tickets. I need to find a way to have excel make a subtotal for the money we recieve for tickets based on whether it's cash or checks. For example Colum A is the payment type and column B is how much they paid. How can I get a sum of all the amount's paid in cash vs. check?

If you could help I would really appreciate it.


EggHeadCafe - Software Developer Portal of Choice
C# Dev Guide to ASP.NET/ADO.NET/XML
http://www.eggheadcafe.com/tutorial...b75c-62447b32e36f/c-dev-guide-to-aspneta.aspx

 

[Ron@Buy]

Amanda sort on column A so that similar payment types are grouped together,
then use the subtotal function. This will provide a subtotal your cash &
checks.
Make sure columns A & B have a header name

 

[JeffB]

Hello Amanda

Try this:

=SUMPRODUCT(--(A2:A5="cash")*(B2:B5))

Just substitute "check" for "cash" for the check amount and ensure the
column A range matches the column B range.

Jeff