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

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

"merlin_au" wrote in message
...
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

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


--
Regards
Frank Kabel
Frankfurt, Germany
"merlin_au" schrieb im Newsbeitrag
...
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