Count info in row

[paulrm906]

Hello this is a formular that I have been trying to workout now for some
time, what I have is a spread sheet (Which I will call "Database") with
staff Name in colmn A, ID Numbers in colmn B and their attendance
records from colmn C to colmn IV (last colmn) going across ways. Now
what I would like to be able to do is have seperate page (which I will
name "Database records") where I can record all monthly/yearly records
so what I need is a formular to to match their ID on the sheet Database
and then for example count across ways how many sick days (SC) they had
in Jan 05. I am of cause not even too sure if this formular is even
possible.

Thankyou in advance if anyone can help me.

Paul Maynard

 

[Bob Miller]

Wrong forum (Almost). If I were you I would chunk the spreadsheet and
switch to Access. You actually told yourself to do this in naming the
spreadsheet "Database."
If you want help in creating the Access database, ask again.
You are in for much toil and tribulation to use a spreadsheet as a
database!