Hi there,
I have a really simple analysis template set up.
Basically what I want is...
In "analysis" worksheet, I want A3 = value in column D of worksheet "Total" based on a filter in B2 of "analysis"...
So A3 will equal 50% if the filter is set to P 1, A3 will equal 43% if the filter is set to P 3, etc. Do I use countif??
I cannot get my head around which cell formula to use...
Can anybody help?
Thank you
Last edited by Lifeseeker; 12-30-2011 at 07:15 PM.
In cell A3, a simply vlookup should do
=VLOOKUP(B2,total!$A$2:$D$4,4,0)
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
No worries. I think I got it..
=IFERROR(SUMIFS(total!B2:B4,total!A2:A4,$B$2)/SUMIFS(total!C2:C4,total!A2:A4,$B$2),"No Patient")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks