Forum Home
Press F1
Thread ID: 102828	2009-09-03 00:49:00	Excel forumla help	DeSade (984)	Press F1

Post ID	Timestamp	Content	User
806442	2009-09-03 16:36:00	problem with programs like Excel is they want you to drag-and-drop what you want to do. You will find it easier if you take a good old pen and paper and write down the cell references and then reference these individually in your formula. Get a blank (Excel)sheet and play with it and check your references. As far as sorting goes, it is simply brilliant if you can work out how to make it sort as you want (i think 5 IF statements?), your original question is also vauge hence that may be your problem	toonttm (14853)
806443	2009-09-07 22:34:00	Don't really think its that vague, the others that have answered understand what I am trying to do. I have 20 data sheets and a formula that counts all the 1's in field D7 on all data sheets the outputs that value to a master sheet for a total. This works fine. I want a 2nd formula that first checks B7 over all data sheets for a specific name, if that name is present then it does the same as above and totals all the 1's. So if I had 20 1's and they were split evenly between two names then the first formula would total to 20, the second formula would total to 10.	DeSade (984)
1 2