Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Sum IF
 
 
LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 45
Default Sum IF
Hi,

Can u pls help me regarding Sum If,

in sheet1 we have code and amt ,

we need result in sheet2 with A2 column reference sum of code value.

In Sheet 1

Code Amt
F001 10
F001 20
F002 40
F001 30
F002 50


We need Result in sheet2 like a,
Code Amt
F001 60
F002 90

Regards

Deen

Reply With QuoteReply With Quote
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Threaded Mode Threaded Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement