summing calls (numbers) in category

[pano]

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]

Hi

Try
=COUNTA(E2:E38) and =COUNTA(G2:G38)

 

[pano]

Thanks that works well

Hi

Try
=COUNTA(E2:E38) and =COUNTA(G2:G38)