Hi guys,

Here is an example of what my table looks like




I want to calculate the total amount that fred is responsible for.
I'm not sure how to use the syntax for excel very well, so i was hoping someone could help. Cheers.

This post has been edited by paulmason411: Nov 29 2007, 01:35 AM

ok, in excel you have collumns and rows. that's all you need. ok i'll guess that the total amount of fred is cell B4+B5, i'm not sure but it seems.
Now to use the formula you'll need a blank cell, D3 for example, select the empty cell and write:
=B4+B5
now press enter and it's done. =)
Greetz
~
João Lopes

I assume you want to total the values for a certain person in that list.
If so, look at the function DSUM() used in an Excel Database. The Database is a collection of rows and columns in the Excel worksheet.



I hope this helps.
PM me with your email address if you would like a copy of this Excel file. It can not be attached to the Forum Posting.
I have attached a pdf that might be easier to understand than the Forum posting.

*file sent by email*

Excel also features Auto Filter.

Auto Filter creates drop down menu according to each column's value. So for example, creating Auto Filter for your table, you can click on the drop down menu and you'll find

(All)
fred
joe

At the end of your table, add a SUM formula that tallies up the column value, i.e. =SUM(B3:B7). Without a filter the sum of all number in B column will appear. Once you use the Auto Filter drop down process, the same SUM field will only add up values of fred or joe.

For more on Auto Filter in Excel try searching on the internet. Auto Filter is the most widely sought out feature but least likely used solution since the majority of Excel users rely on LOGIC formula than filtering process.

Thanks jlhaslip, i got the hang of it and your method works really well.

Replying to paulmason411
You could just use SUMIF(range with names, "name you want",Range with values)

-reply by chuck