summing calls (numbers) in category

Giganews Newsgroups
Subject: summing calls (numbers) in category
Posted by:  pano (jenaw…@netspace.net.au)
Date: 19 Jan 2007

Hi all summing calls (numbers) in category ?

My problem is I want to sum the amount of calls.
3 columns
A              E          G
CALL      code        INF
1              ZD
2              ZA
3              Z1
4                            10AB
5                            15AC
6                            25AD
7                            20AB
8              ZB
9              ZH
10                          10AZ

= Total Calls 5            5

so that I end up with

total 5 calls under Code and 5 calls under INF this could go onto 38
calls. mind you that some cells under a1 maybe blank

if that makes sense.

Thanks in advance

Replies