Find your solution!

simer · 06-Oct-2009, 12:08 PM #1

Hi All,

I have an Excel puzzle that I cant seem to figure out. What I have is a list of volunteers running down the work sheet. Across I have the different shift dates with the number of spots available for volunteers. Each Shift it devided into AM or PM.

What I want is to have a row for each volunteer which will have an AM or PM in the column that corresponds to the shift date. I would then like the total of remaining shifts to decrease with every entry.

The formula i tried to use that doesnt work:
=B3-SUMPRODUCT($B$13:$B$5000="AM")
=B3-SUMPRODUCT($B$13:$B$5000="PM")

I have attached the worksheet. Any help would be amazing.

The Villan · 12:58 PM

=b3-countif($b$13:$b$5000,"am")
=b4-countif($b$13:$b$5000,"pm")

That should do it.

If that is what you want, can you please scroll to the top of the thread and click on the SOLVED button

simer · 06-Oct-2009, 04:36 PM #3

Thanks!

The Villan · 06-Oct-2009, 04:38 PM #4

You are very welcome

The Villan · 06-Oct-2009, 04:41 PM #5

One comment.
If you took the dollar sign away from in front of the B, you can then copy that formula across.

=b3-countif(B$13:B$5000,"AM")
=b4-countif(B$13:B$5000,"PM")

Tag Cloud
access audio black screen blue screen boot bsod connection crash dell desktop driver drivers dvd email error excel excel 2003 firefox hard drive hardware internet keyboard laptop malware monitor motherboard network networking outlook problem ram recovery router safe mode slow sound spyware tdlwsp.dll trojan upgrade vba video virus vista vundo windows windows 7 windows vista windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for: