#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LostSam
 
Posts: n/a
Default complex function

A B C
1 2600 2
2 2600 1
3 2600 4 7
4 1431 3
5 2100 3
6 2100 5 8

check A if numbers are the same then add B and total to C
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default complex function

Check out the Data Subtotals feature......it will give you a nice
report.....

hth
Vaya con Dios,
Chuck, CABGx3


"LostSam" wrote in message
...
A B C
1 2600 2
2 2600 1
3 2600 4 7
4 1431 3
5 2100 3
6 2100 5 8

check A if numbers are the same then add B and total to C



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LostSam
 
Posts: n/a
Default complex function

thank you!!!!!!!!!!!!!!!

"CLR" wrote:

Check out the Data Subtotals feature......it will give you a nice
report.....

hth
Vaya con Dios,
Chuck, CABGx3


"LostSam" wrote in message
...
A B C
1 2600 2
2 2600 1
3 2600 4 7
4 1431 3
5 2100 3
6 2100 5 8

check A if numbers are the same then add B and total to C




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
complex excel formula Array how do I convert it to a vba Function Rob Excel Worksheet Functions 1 April 10th 06 07:06 PM
Inserting a string seach within a complex function DJ_Swammi Excel Worksheet Functions 3 December 15th 05 08:30 PM
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


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

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"