sumif maybe?
I am not getting uptight, I am just telling you how to conduct yourself in a
sensible manner if you want us to continue to give free help, we are under
no obligations to help, and it is up to you to conduct yourself in a manner
that does not antagonise those that you seek help from. Multiple threads
does not fit that description IMO.
If you think I was being abusive, I think you must have led a very sheltered
life. I was direct, but certainly not abusive.
And check the times on the previous post, you will see that all of my posts
in that thread are before your first post in this. So you clearly decided to
ignore my comment and open a new thread for what reason I know not.
I will now bow out, I wish you well in your search for a solution, but I
will not be participating in seeking it any further.
--
__________________________________
HTH
Bob
"Esradekan" wrote in message
...
On Aug 28, 8:08 pm, "Bob Phillips" wrote:
Stick to the one thread and stop wasting people's time by replicating
questions.
--
__________________________________
HTH
Bob
"Esradekan" wrote in message
...
lets try again.
Column Headers are (B1:P1) Staff 1 Staff 2 etc
A2:A27 is a date range (fortnightly dates range called "Date")
B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27)
etc
I need to find the total value of the figures for each month.
I have January, February etc in C31:N21 (to December) and require the
totals for each staff member for each month. Staff members listed
B32:B61
Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc.
what formula can i use?
TIA
Esra- Hide quoted text -
- Show quoted text -
Dont get uptight Bob, maybe if you had of answered my earlier post, I
wouldnt of thought that i wasnt so clear with that post and wouldnt
have decided to post again, trying to be clearer.
I appreciate your efforts in answering posts to this newsgroup, I
understand you probably dont have to, but Bob, I dont need 'abuse'
either. I have been polite with you, please be so with me. Dont
"tell" me, ask me. You get better results with sugar than you do with
vinegar.
I see you finally answered my post, I guess because you saw this one.
Im still no further ahead with this and your right, your solution did
not work.
Still TIA,
Esra
|