Search:

Sorry about that, I did go through some of your other answers and I am really impressed with your work.

The formula =IF(COUNTIF($B$2:$B$7, ">0")=0, 0, SUM($B$2:$B$7) / COUNTIF($B$2:$B$7, ">0")) only solves the problem not to include a zero value in the average calculation
The formula...

I have a Word document with textbox fileds that is completed by users.

How can I extract the information from these boses into an excel database?

Any suggestions will be great!!

All I could come up with si using the dcount and subtracting the count


Name Feb 07
Roger x
Lisa
Bob x
Lisa
Lisa x
Lisa

sorry my fault - I didn't cater for decimals, this should fix the problem
...

Try dragging the row higher with your mouse - the same way you would a column

you can combine the IF, REPLACE function to this

=REPLACE(D11,LEN(D11),1,IF(VALUE(RIGHT(D11))<3,0,IF(VALUE(RIGHT(D11))<6,5,IF(VALUE(RIGHT(D11))<10,9,0))))

where D11 is the cell with the...

you can combine the SUMIF and COUNTIF functions
=SUMIF(B2:F2,">8")-(COUNTIF(B2:F2,">8")*8) where B2:F2 is your range of hours worked

Hope this helped

you could also do the following

=IF(B:B="A",COUNTIF(A:A,"A0067"),0) in another cell do the same for B

or you could reference to either A or B


good luck

I agree with ScottGem Vlookup will work as long as the names are the same remember to add the "false" indicator at the end of your lookup, if you do not add it excel will return the nearest match and...

In excel press "Ctrl" and ~ do it again to hide formulas

Try using pivot tables

Sorry I see you alrready tried that - can you post an example of a cell that won't fit?

You have to change your row height as well to see al the data
Format
Row
Autofit

I suggest having groups of drop down lists relating to groups of lookup tables seperatly in the workbook.
Then create a set point for the drop down list and lookup table that will be used. These...

You can simply use the count if function in excel

on sheet 2 in the cell where you want the total of Hawaiin people for instance type the following formula
=COUNTIF(Sheet1!B:B,"HI")
where...

You have to merge the cells on excel select the rows and columns you want to in the form heading click on Format - cell - allignment merge or simply click on the merge icon