[SpaceCowboy706]

I am having a problem trying to figure out how to use the "countif" function in excell and im not even sure if its the appropriate function to be used, for what im wanting to do. Here is a little background information on what im doing...

I’m trying to make a log to track monthly totals for completed installs and trouble calls. I have found how to count if one install or one trouble call was completed for a day, but I cannot figure out how to:

1) count if more than one Trouble call was completed on the same day
2) count if more than one Install was completed on the same day
3) count if more than one Install and Trouble call was completed on the same day

Examples would be I completed 5 jobs, all for trouble calls today… or… I completed 5 jobs, all for Installs today… or… I completed 5 jobs, three for Installs and 2 for Trouble calls today. In the linked excell document Installs are represented by an "I" and trouble calls by a "T".

Here is a plain sample of what im using... Theres no viruses or any of that crazy stuff in it, its just a excell document is all.

http://members.cox.n...2345/Sample.xls

Any help would be greatly appreciated.

[Advertisements]

Nevermind on this... figured it out

[SpaceCowboy706]

Nevermind on this... figured it out