........................
........................
Last edited by danielgri14; 04-09-2011 at 11:11 PM.
I see you are using 2007 so check out Sumifs in Excel help
HTH
Regards, Jeff
I dont think it is a sumif maybe a countif because I am just adding up words.
I was thinking I have to loop through each cell and have like production= production +1 but I have to do it for multiple columns so I can't figure out a way to do that.
Can you post a small sample workbook with what results you desire?
.............
Last edited by Leith Ross; 04-10-2011 at 12:57 AM. Reason: Removed workbook at request of OP
I need a little more explanation here. After applying a filter for Production I see there are 563 records out of 958 , but how do you come up with 0.588 for Production/Tester 1?
the .588 is just a percent of the total of production/tester1... 563/958
I have code that can find the probabilty of all the states for one header, I am just having trouble for it going to the next column over and then finding all the probabilities of each state and putting it in the column over
Build a table the way you have on Sheet4 and then enter
=COUNTIF(Bldg51Data!A$2:A$959,$B17)/COUNTA(Bldg51Data!A$2:A$959)
Drag across and down
Hey Im pretty sure im doing that put Im getting 0 for everything.
Heres what i did
Last edited by Leith Ross; 04-10-2011 at 12:58 AM.
Change $B17 to $A20
=COUNTIF(Bldg51Data!A$2:A$959,$A20)/COUNTA(Bldg51Data!A$2:A$959)
Thanks dude your the man, how can i repay you? paypal 10$?
Your thanks is enough
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks