Computer Help and Support

Narkos

(1,185 posts) Sun Feb 12, 2012, 06:52 PM Feb 2012

Counting values in Excel by column

Hey all,

I want to be able to count how many times a particular employee works a Sat , Sun or any other day. I've attached a video clip to show you what I am talking about. I used to give Sat and Sun calls a specific name like CSA or CSU and write a formula counting the number of CSA's in a row, but I'm using a new program and will only be able to go by one value. Any help would be appreciated!

2 replies

= new reply since forum marked as read

Highlight:

Counting values in Excel by column (Original Post) Narkos Feb 2012 OP

Had to do this at work the other day CurtEastPoint Feb 2012 #1

I don't know how often you change this, but there's a dirt simple way to do it... HopeHoops Feb 2012 #2

CurtEastPoint

(18,685 posts)

1. Had to do this at work the other day

Reply to Narkos (Original post)

Sun Feb 12, 2012, 07:44 PM

Feb 2012

and had to Google to find out the solution.

Have you looked here? http://office.microsoft.com/en-us/excel-help/countif-HP005209029.aspx

HopeHoops

(47,675 posts)

2. I don't know how often you change this, but there's a dirt simple way to do it...

Reply to Narkos (Original post)

Tue Feb 14, 2012, 08:06 PM

Feb 2012

=IF(a1="c",1,0)+IF(b1="c",1,0)+IF(c1="c",1,0), etc.

If it is a static template that you fill in from scratch every two weeks, that will work great. If it is more dynamic, you need some other tricks.

On Edit: You can also do this with hours worked IF(a1>0,1,0) or IF(a1>0,a1,0) to sum them all.

Reply to this discussion