All,
Thanks alot for your help, formula are working.
Hugs & Love ...
On Wed, Nov 10, 2010 at 2:30 PM, saggi wrote:
>
> .e. In cell C4:
>
>
> =text(B4,"mmm")
>
>
>
> After this use
>
> =SUMIF($C$3:$C$25,I8,$A$3:$A$25)
>
> On Nov 10, 1:45 pm, ashish koul wrote:
> > chekc the attachment se
.e. In cell C4:
=text(B4,"mmm")
After this use
=SUMIF($C$3:$C$25,I8,$A$3:$A$25)
On Nov 10, 1:45 pm, ashish koul wrote:
> chekc the attachment see if it helps
>
>
>
>
>
> On Wed, Nov 10, 2010 at 8:03 AM, wrote:
> > Hi,
>
> > Write following formula beside date column, i.e. In cell C4:
>
>
chekc the attachment see if it helps
On Wed, Nov 10, 2010 at 8:03 AM, wrote:
> Hi,
>
> Write following formula beside date column, i.e. In cell C4:
>
> =text(B4,"mmm")
>
> Now copy this formula in all rows of coloumn C, You will get Month name
> like Aug in cell C4.
>
> Now you can use sum if.
>
Hi,
Write following formula beside date column, i.e. In cell C4:
=text(B4,"mmm")
Now copy this formula in all rows of coloumn C, You will get Month name like
Aug in cell C4.
Now you can use sum if.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: janet dickson
Sender:
hi,
Check this website hope you will find the resolution
http://www.homeandlearn.co.uk/excel2007/excel2007s6p4.html
Thanks,
Raj
On Tue, Nov 9, 2010 at 11:19 PM, janet dickson wrote:
> Hello Excel Gurus,
>
>
> I encountered a challenge on using SUMIF FUNCTION. Help me on summing total
