Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rajesh
 
Posts: n/a
Default sumif help ---urgent

I have one sheet called "Data" and a sheet called "summary".

The format of "Data" is as follows:

Agent TL OT
592400 Mujeeb Khan 4.37
592379 Leo Muthu 0.00
592389 Milind Dovhal 0.09
592390 Aslam Hussain 0.02
592421 Murali Krishna 3.99
592426 Murali Krishna 4.00
592481 Shobhan Choppala -0.02
592485 Vamsidhar V -0.44
592506 Chitra Kumari 0.08
592509 Shobhan Choppala -0.01
592380 Karthikeyan R 0.00
590230 Mujeeb Khan 4.32
590231 Vibhuti Khanna 9.60
590236 Binoy VK 0.00
590249 Hariharan Sarma 0.21
590250 Hariharan Sarma 0.67
590252 Nitin Attri 9.68
590265 Chitra Kumari 0.33


The format of "Summary" is as follows:
TL OT
Abraham Syed
Binoy VK
Hariharan Sarma
Milind Dovhal


What I need in the OT column (of "Summary" sheet is sum total for the TL
from the column OT in the "Data" sheet if the value (in OT column) for each
Agent of that TL is greater than 0.

Appreciate your help.

  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
easiest way: use a pivot table for this:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Rajesh" schrieb im Newsbeitrag
...
I have one sheet called "Data" and a sheet called "summary".

The format of "Data" is as follows:

Agent TL OT
592400 Mujeeb Khan 4.37
592379 Leo Muthu 0.00
592389 Milind Dovhal 0.09
592390 Aslam Hussain 0.02
592421 Murali Krishna 3.99
592426 Murali Krishna 4.00
592481 Shobhan Choppala -0.02
592485 Vamsidhar V -0.44
592506 Chitra Kumari 0.08
592509 Shobhan Choppala -0.01
592380 Karthikeyan R 0.00
590230 Mujeeb Khan 4.32
590231 Vibhuti Khanna 9.60
590236 Binoy VK 0.00
590249 Hariharan Sarma 0.21
590250 Hariharan Sarma 0.67
590252 Nitin Attri 9.68
590265 Chitra Kumari 0.33


The format of "Summary" is as follows:
TL OT
Abraham Syed
Binoy VK
Hariharan Sarma
Milind Dovhal


What I need in the OT column (of "Summary" sheet is sum total for the

TL
from the column OT in the "Data" sheet if the value (in OT column)

for each
Agent of that TL is greater than 0.

Appreciate your help.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use SUMIF to return sums between two values located in cells ScottBerger Excel Worksheet Functions 2 April 23rd 23 09:05 PM
SUMIF between dates Bruce Excel Worksheet Functions 3 November 25th 04 06:25 PM
SUMIF across a range of worksheets Mike@Q Excel Worksheet Functions 3 November 24th 04 03:36 PM
SUM(IF( Array to avoid #NUM! values Elijah Excel Worksheet Functions 7 November 21st 04 03:17 PM
sumif to add data in multiple sheets Sues Excel Worksheet Functions 4 November 18th 04 07:54 AM


All times are GMT +1. The time now is 10:19 AM.

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

About Us

"It's about Microsoft Excel"