I am currently using a formula array, kindly provided by Paul Sheppard, as
follows:-
{=SUM((Sheet1!$B$2:$B$9=Sheet2!A2)*(Sheet1!$C$2:$C$9<>""))}
This array basically provides me with the number of entries with a specific

I am doing a count of information in rows.  I want to show certain
information in these rows, but don't want to count it in the total.  What can
I do?

Hello
I have tried below, and it works superb - but not all of the data i want to
sumarise is on the same line on each sheet.
so i want to do something like this

I have data that is imported into Excel and for some reason, not all the
numbers are in one column but in three.  I have been manually moving the
numbers from the incorrect columns and putting them with the other numbers
because I need to do subtotals on the numbers.  I think I ...

I need to format a cell to show hours and minutes. For example 1'30".
How do I do this?

I'm not sure if I am using the correct function?  I have several spreadsheets
in the same workbook.  Within each worksheet are columns for date 'MMM-YY'
and value '£'.  Not every worksheet has the same dates so therefore the row
posions vary so I need to select teh specific name ...

Can you create an if statement for me?  
If a4=<75,001 fee=2.00
if a4=>75,001 but <125001 fee=1.75
if a4=>125001 but<250001 fee=1.50

In my spreedsheet I figure plant hours but the problem I have say my hours
are 7:30 hours. For other calculations I need 7 1/2 hours to read as 7.5. Is
there a way to change 7:30 into 7.5 hours
thanks in advance

how do I create new functions in Excell? a simple example is I'd like a
MEAN() function that does the same as the AVERAGE() function. I'd like it
available to all work book (i.e. save it with Excell, not a particular
workbook).

Hi Folks - I am comfortable using the VLOOKUP function. Here's my problem:
I have a 15 row column of TEXT in SHEET1 that looks like:
TimeSlot
2-3:30

I am trying to re-jig a formula that shows hours worked for a particular
day, to showing any absence detail shown for a particular employee. I have
the fllowing formula which doesn't work and I'm not sure why. A similiar
formula works for me getting basic hours worked etc

Why when I copy from a totally blank cell to another, instead of a blank
cell, I get a 0 (zero)???
I wish the cell to be blank when I press Ctrl "C" and "Ctrl" V.
How to do it?

Could some one please help me to change the default formatting
[text,background color, border lines etc.] on a permanent basis.
I know that we could change the format of one comment in the excel
worksheet, by selecting the border of that comment and then pressing

I would liketo create a spreasheet that will highlight the value in the first
column if there ia value in another column of the same row.  

I have produced a workbook with a main sheet which summarises other
information from spreadsheets in the same workbook.  I have used VLOOKUP and
this is fine when there is only one row of data to summarize from each
spreadsheet.  Can anyone help me with a suggestion to ...