sumif

F

Firas

In Excel Office 2003, I am trying to use the sumif function in the following
way [D2=sumif(A2:A720,B2,C2:C720)] to sourt my deferent business telephone
call for each deferent number for a rang of data impoted from a cvs data file
but it is not working, please help?
 
D

Don Guillett

This formula should give you the sum of c2:c720 for each match of c2 in
a2:a720.
If this is not the problem, it's possible your numbers are not formatted as
numbers.

=sumif(A2:A720,B2,C2:C720)
 
S

Sandy Mann

Firas,

If you are in fact trying to count the number of telephone calls made to a
number then it may be that you should be using COUNTIF rather than SUMIF

HTH

Sandy
 
Top