$$Excel-Macros$$ Re: Sum Formula allowing for sub-totals

2015-05-18 Thread Mandeep Baluja
Can you please mark color yellow to those cells which needs to be sum !! On Tuesday, May 19, 2015 at 6:18:46 AM UTC+5:30, sswcharlie wrote: > > Hi Mandeep > > Sheet attached.I want to check that the total of entries only adds up > to grand total. A double check to make sure everything in. S

$$Excel-Macros$$ Re: Sum Formula allowing for sub-totals

2015-05-18 Thread sswcharlie
Hi Mandeep Sheet attached.I want to check that the total of entries only adds up to grand total. A double check to make sure everything in. Say total of E11:E220 Thanks Charles On Monday, May 18, 2015 at 7:05:40 PM UTC+12, Mandeep Baluja wrote: > > Can we have the sheet ??? > > On Mo

$$Excel-Macros$$ Re: Sum Formula allowing for sub-totals

2015-05-18 Thread Mandeep Baluja
Can we have the sheet ??? On Monday, May 18, 2015 at 12:27:13 PM UTC+5:30, sswcharlie wrote: > > Hi > > XL2000 > > Have searched for this with no luck. > > Have a column with figures entered by user and also some sub-totals as a > result of formula. > > How do I have a formula to add all the ente