Hi,

I am stuckup up in using Vlookup & Sum Function.

Sheet 1
1 January 100
2 February 200
3 January 500
4 March 300
5 January 400


Sheet 2

We have columns of Month Name
January | February | March |

Whats required is
Under January auto summation should happen as 1000
Under February auto summation should happen as 200
Under March auto summation should happen as 300

Can anyone help.

Thanks in Advance.

Rgds

Akash Maheshwari

Hi Akash,

Am Tue, 5 May 2015 04:24:29 -0700 (PDT) schrieb Akash Maheshwari:

Sheet 1
1 January 100
2 February 200
3 January 500
4 March 300
5 January 400

Sheet 2

We have columns of Month Name
January | February | March |

in Sheet2 A2:
=SUMIF(Sheet1!$A:$A,A$1,Sheet1!$B:$B)
and copy to the right


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Thanks Sir,

It was of great help.

One more thing, I an using one formula for pulling average with similar example what I had mentioned in the earlier mail.

=AVERAGEIF(Sheet1!a1:C100,Summary!C4,Sheet1!N1:N10 0)

Its working fine if it finds the value but where there is no value it giving me output as #DIV/0!

Insted of #DIV/0! I would like to display 0. Pls help.

Best Regards

Akash Maheshwari

hi,

Am Tue, 5 May 2015 06:22:00 -0700 (PDT) schrieb Akash Maheshwari:

Insted of #DIV/0! I would like to display 0. Pls help.

try:
=IFERROR(AVERAGEIF(Sheet1!A1:C100,Summary!C4,Sheet 1!N1:N100),0)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

On Tuesday, 5 May 2015 16:54:33 UTC+5:30, Akash Maheshwari wrote:
Hi,

I am stuckup up in using Vlookup & Sum Function.

Sheet 1
1 January 100
2 February 200
3 January 500
4 March 300
5 January 400


Sheet 2

We have columns of Month Name
January | February | March |

Whats required is
Under January auto summation should happen as 1000
Under February auto summation should happen as 200
Under March auto summation should happen as 300

Can anyone help.

Thanks in Advance.

Rgds

Akash Maheshwari

Super cool Help

Thanks a tonn

đọc truyện tranh 17-sai kiss to dilemma Thầy giáo : Em hãy cho biết Mặt Trăng xa hơn hay Mặt Trời xa hơn?
Trò : Mặt trời xa hơn ạ .
Th̀y : Vì sao ?
Trò : Vì sao của Khởi My ạ
Th̀y : ko, tại sao ?
Trò : Tại sao của Ưng Hoàng Phúc ạ !
Th̀y : Ko , ý th̀y là Why đó .!
Trò : Why ? À ! Why của DBSK .
Th̀y : Trời ơi ,tôi phải làm thế nào ? Xem thêm đọc truyện tranh anh chàng lạnh lùng