Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2007

Tip: Looking for answers? Try searching our database.

summing calls (numbers) in category

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pano - 20 Jan 2007 07:26 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.