LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Arge
 
Posts: n/a
Default Counting a range of fields with an "X"

I am setting up a very simple spread sheet with a work schedule for
volunteers.

In Fields A-4 through A-24, I have their names. In fields B-4 to A-24 I
have an X showing they are working that date. These columns are repeated
all the way though T-4 to T-24.

What I am trying to do is have a count of the X's by column at the bottom of
each column.

I have tried several different formulas, but keep receiving the error
message of the formula you typed contains an error..

I have been reading the newsgroup to see if it had been covered, but could
not find anything on it. Of course I could have followed the newsgroup for
more than a day and maybe stumbled across it.

Any suggestions would be appreciated
Bob


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Spreadsheet with Merged Fields Linda L Excel Discussion (Misc queries) 1 January 22nd 05 12:58 AM
named range refers to: in a chart Spencer Hutton Excel Discussion (Misc queries) 1 December 14th 04 10:15 PM
Counting values within a Date Range Jana Excel Discussion (Misc queries) 7 December 9th 04 10:18 PM
range name Pedro Excel Worksheet Functions 0 November 9th 04 06:22 PM
Counting Function Dilemma Simon Lloyd Excel Worksheet Functions 0 November 8th 04 03:13 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"