Thanks for your replies,
The formula I'm attempting to use is:
=SUMIF($A$3:$A$2001,M3:M100,$G$3:$G$2001)
I'm trying to get it to calculate the duration in minutes of calls tha
a group of moblie phones make to each other, this will then eventuall
be expressed as a percent of the total duration of all calls that grou
made.
In the worksheet I'm using Column A is an imported list of all number
dialled by one specific handset from the group. Column G is th
duration in minutes of each number dialled. Column M contains a list o
all the existing phone numbers within the group.
From my understanding the range A3:A2000 should be evaluated by th
criteria M3:M100 (comparing the existing phone numbers to the number
dialled) and then the duration in minutes for those cells defined b
the criteria should be summed returning the total number of minute
that the specific handset used in calling other group members.
Unfortunately from my test it only returns a value of 0 unless I modif
the criteria to reflect only 1 cell from the range M3:M100. It the
works fine but only calculates the calls made to the number in tha
cell.
I know I can get around this with something along these lines:
=SUMIF($A$3:$A$2001,M3,$G$3:$G$2001)
SUMIF($A$3:$A$2001,M4,$G$3:$G$2001)
SUMIF($A$3:$A$2001,M5,$G$3:$G$2001) and so on and so on…
The problem with this is when I have to analyse a large number o
handsets, 100+ etc, I will spend more time entering the formula tha
doing the actual analysis.
As I’m also at the “monkey with a keyboard” stage of learning VBA
which I’m sure would be able to perform the required task easily, I’m
bit stumped… Especially as the formula doesn’t return any error.
Any help you could give me in pointing me in the right direction to se
where I have gone wrong would be greatly appreciated.
Many thanks
