Re What is the formula for adding multiple numbers in a cell

[Guest]

Hi
Hoping someone can help me, i know it's a really basic thing but i just need
to know how to add multiple numbers to single excel cell. The spreadsheet is
being used for a monthly sales report & i need to add the daily sales figures
to each persons name in the report & have it auto tally each personal totals
over the month.

Thanks
Tony

 

[Hari]

Hi,

If u want to sum based on multiple conditions ( persons name, month etc )
then check out SUMPRODUCT formula at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Thanks a lot,
Hari
India

 

[Frank Kabel]

Hi
for this you may have a look at SUMIF in the excel help. e.g.
=SUMIF(A:A,"John Smith",B:B)
totals all values in column B where column A is equal to 'John Smith'. You
may also take a look at pivot tables for this