Help Required using SUM function with Vlookup
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 |
Help Required using SUM function with Vlookup
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 |
Help Required using SUM function with Vlookup
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 |
Help Required using SUM function with Vlookup
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 |
Help Required using SUM function with Vlookup
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?
Tṛ : Mặt trời xa hơn ạ . Th̀y : V́ sao ? Tṛ : V́ sao của Khởi My ạ Th̀y : ko, tại sao ? Tṛ : Tại sao của Ưng Hoàng Phúc ạ ! Th̀y : Ko , ư th̀y là Why đó .! Tṛ : 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 |
All times are GMT +1. The time now is 05:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com