ExcelBanter - complex function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - complex function (https://www.excelbanter.com/excel-worksheet-functions/86462-complex-function.html)

LostSam

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

CLR

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

LostSam

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

All times are GMT +1. The time now is 01:14 AM.