Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel Function Help


  • This topic is locked This topic is locked

#1
SpaceCowboy706

SpaceCowboy706

    Trusted Tech

  • Member
  • PipPipPipPip
  • 1,175 posts
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.
  • 0

Advertisements


#2
SpaceCowboy706

SpaceCowboy706

    Trusted Tech

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,175 posts
Nevermind on this... figured it out :)
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP