98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Urgent Priority · Version 2003
Fri 17 Apr 2009, 09:45Delegate Rachael said...
Rachael has attended:
Excel Intermediate course
Excel Advanced course
Formulas
Hi Stephen
wondered if you could help me i am currently using
=COUNTIF('Apr Activity'!$C$7:$AA$65536,"Admin")
formula to count and area of cells. however i now need to count those cell ONLY IF my first row "accountable" = ASR..
i think it would be easyier if i sent you a copy of what i am trying to do but can attach a file for some reason...
so imagine i have four small tables side by side this represents the weeks in the month.
each table has 5 colums in
Accountable /Date/Clien/action/Qualifying information & Next steps.
so i am telling my formula to read the WHOLE month and if its says admin count them up and give me a number. i now want the same but only if my first row of each table Accountable says ASR.. but i stil only want one figure i dont want 4 for each month..
Thanks
Fri 17 Apr 2009, 10:56Trainer Stephen said...
RE: Formulas
Hi rachael
Thanks for your question
If you email me the file I will investigate and get back to you
my address is stephen@stl-training.co.uk
Regards
Stephen
Wed 22 Apr 2009, 09:57Trainer Stephen said...
RE: Formulas
Hi Rachel
Thanks for the file which I have now had a chance to study. I have been training on site for the last 2 days and have had no internet access
Can you clarify the following for me.
1. Do you require each row in your target table to count how many rows of that action there are here accountable = asr? So row 1 would how many rows have admin in the action column and asr in the accountable column and so on.
2. If you are using countif, then why does the summation row at the bottom have a currency format?
Thanks
Stephen
Wed 22 Apr 2009, 10:04Delegate Rachael said...
RE: Formulas
Hi Stphen
No problems thanks for getting back to me
If you look at the Activity summary sheet at the top table and click in cell B3 this will give you the formual that i currently using and counts all "actions" for all the weeks in one month it doesnt matter who is "accountable"
However i am trying to get the bottom table to only count "Actions" if the "Acccountable" states "ASR" in the Activity sheets
the currancey is picked up for else where. thats a monthly target we need to achive... - just leave that there.
Does this clarify?
Thanks again
Mon 20 Jul 2009, 09:45Trainer Stephen said...
RE: Formulas
Hi Rachael
Thanks for your question
I apologise for the delay in replying. I have been away from work for some time due to illness. I realise that you may have already solved the problem, if this is not the case could you please advise me so that I can giver it my urgent attention
Regards
Stephen
Mon 27 Jul 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Switch on smart tags – Excel 2007In order to use smart tags, make sure they are turned on, to do this: |
