Hi
pfa
From: raghunandan rallapalli
To: excel-macros@googlegroups.com
Sent: Tuesday, 11 December 2012 5:59 PM
Subject: $$Excel-Macros$$ need formula please
sir,
I need a formula for total sum of each account no wise as given in excel sheet.
Thanks in ad
Hi Raghu,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli <
raghunandan.rallapa...@gmail.com> wrote:
> sir,
> I need a formula for total sum of each account no wise as given in excel
> sheet.
>
> Thanks
your file (it's working only on one condition, that you account_no column is
SORTED!!!)
I didn't want to advice you to do pivot table as per request function.
awel
From: raghunandan rallapalli
To: excel-macros@googlegroups.com
Sent: Tuesday, December 11, 2012
Hi,
find below & use this =SUMIF($A$2:$A$23,A2,$C$2:$C$23)
thankx
satendra
On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli <
raghunandan.rallapa...@gmail.com> wrote:
> sir,
> I need a formula for total sum of each account no wise as given in excel
> sheet.
>
> Thanks in advance please
