calculate

[oracle_coorgi]

HI
NEED marco to calculate the called number which is in c cell the total duration of call made THAT IS IN CELL D
eg:if the called number is 39220174 total duration is =663 in sheet2 any cell

Attached the sample file

[Steven_Daniel]

Hello

Just copy the following formula into your Sheet2 worksheet.

=SUMIF(Sheet1!C:C,"39220174",Sheet1!D:D)

You will see the total of 663 being produced.

NOTE: This assumes that you have a sheet name of Sheet1 and your Duration column resides in Column D.

Hope this helps you out with what you are wanting to achieve.

Cheers,

[oracle_coorgi]

hi
i needed something different
i need to calculate for particular call number and total the duration
eg:sheet2 cell A callnumber cell b total duration
eg:39220174 663
41128459 2381