Solved: Excel Totaling Puzzle

simer · 06-Oct-2009, 01: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 · 01: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, 05:36 PM #3

Thanks!

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

You are very welcome

The Villan · 06-Oct-2009, 05: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 acer asus bios bsod computer crash driver drivers error ethernet excel freeze gaming gpu hard drive hardware hdmi internet laptop mac malware memory monitor motherboard music network printer problem ram registry router server slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

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

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!