Evening,
If anyone could help I would be very greatly, otherwise this is going to take forever
I'm using this formula:
=AVERAGEIF('Input Sheet'!G:G,"AARD",'Input Sheet'!H:H)
It works, but I'm looking at having to change the "AARD" about 112 times to different things.
What I would like to do is change it, so rather than putting whatever it is looking for within the "", I want it to check a cell, for example C4.
Thanks for any help.
Last edited by Cmorgan; 09-16-2011 at 04:28 PM.
So just put that in the formula, surely you tried it?
=AVERAGEIF('Input Sheet'!G:G, C4, 'Input Sheet'!H:H)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thanks, for this. I was putting , and/or " in the wrong place - total newbie to excel.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks