sumif formula

[Sreehari]

I want to calculate the sum of amounts for a specific year . Please help me with a formula for doing this.

sample attached.

Summary sheet-sheet1


Sheet 2

 

[chirayu]

attached sample

 

[NARAYANK991]

Hi ,

Try this :

=SUMIF(National_disputes_Outpay_Aging!$A$6:$A$43, B4, National_disputes_Outpay_Aging!$C$6:$C$44)

Narayan

 

[Sreehari]

Thanks a lot Narayan for your valuable time and support . you are awesome..

 

[Sreehari]

Hi ,

one last question , if I want to express the values in millions then what modification I need to do in this formula.

 

[NARAYANK991]

Hi ,

one last question , if I want to express the values in millions then what modification I need to do in this formula.

Hi ,

If you want an actual value , then divide the posted formula by 1000000 ; otherwise , if you just want the displayed value to be in millions , then use a Custom cell format of :

#,##0.00,,

or

#,##0,,

depending on whether you want decimal places or not.

Narayan

 

[Sreehari]

chirayu,

Your formula also is working . thanks a lot.

 

[Sreehari]

thanks , Narayan.