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
Roger Govier - 20 Jan 2007 07:50 GMT
Hi
Try
=COUNTA(E2:E38) and =COUNTA(G2:G38)

Signature
Regards
Roger Govier
> Hi all summing calls (numbers) in category ?
>
[quoted text clipped - 23 lines]
>
> Thanks in advance
pano - 20 Jan 2007 09:37 GMT
Thanks that works well
> Hi
>
[quoted text clipped - 33 lines]
> >
> > Thanks in advance