lynnnow
09-29-2011, 03:57 AM
Hi Guys,
I've got a sheet with two columns per date, i.e., Mins and WC.
I need to horizontally sum the Mins and WC separately at end of the table.
The SUM formula allows for only 30 items. I've been reading the SUMPRODUCT article by XLD but still need to get my head around the subject.
Alternatively, I can use the "+" symbol, but considering the difference in the number of days of each month, updating the formula and maybe even missing out a column can lead to a wrong result. Will SUMPRODUCT work for this? Is there any other way?
I'm using Excel 2003 on Win XP.
I'm attaching some sample data.
Thanks in advance.
Lincoln
I've got a sheet with two columns per date, i.e., Mins and WC.
I need to horizontally sum the Mins and WC separately at end of the table.
The SUM formula allows for only 30 items. I've been reading the SUMPRODUCT article by XLD but still need to get my head around the subject.
Alternatively, I can use the "+" symbol, but considering the difference in the number of days of each month, updating the formula and maybe even missing out a column can lead to a wrong result. Will SUMPRODUCT work for this? Is there any other way?
I'm using Excel 2003 on Win XP.
I'm attaching some sample data.
Thanks in advance.
Lincoln