I've now worked out how to use the following formula:
=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),(C1:C10))
which gives me the summed value for jon & B's.
I have now realised that I have a volume column that shows how many of that

Does anyone have any suggestions on macro coding on following situation?
Workbooks.Open Filename:="E:\1.xls", UpdateLinks:=3
When macro coding open the file 1.xls, it will update the links from the
data.xls.

I am trying to get the average of a multiple cell range. The criteria range
and sum range are not the same size. Does countifs work the same way
regarding this?
Here is the formula I am trying to rearrange to work.

I am keeping a running log of mutual fund activity. Something like this:
Date    Shares    Price    Daily    Total    Gain/Loss
6/1/2007    503.30    40.53        20,398.83    0.00
6/2/2007    503.30    40.59    0.06    20,429.03    30.20

I have 2 spreadsheets, one listing a list of sales, the other showing a
summary of sales by each month. how do i get the summary from the detailed
list by month.

How can I create a (new) sheet showing ALL results from a datasheet meeting
a criteria(cell value),
I tried INDEX/MATCH, but got only the first found,
It should be possible somehow, But I have no clue

Hi All - I've looked all over for the answer to this question but. ..:(    
I have a list of names that appear multiple times that I need to match with
a "YES".
This list also contains names I want to ignore. l would like to put a "yes"

Could someone please tell me how to use a calendar control in a worksheet.
For example, Cell A1 is a required date field. Is it possible to have a
calendar control pop up when you click on cell A1, select a date and have
the date selected entered in cell A1.

Hi! I am trying to write a formula that will calculate sales tax and add
shipping charges and I am not sure how to go about it.
I need the whole column formatted this way.
Example:

Hello,
I have a large data file (10.000 rows / 10 columns) from wich I have to
process data. I use a lot of index match formula's, lookup tables  and data
validations, in multiple sheets

I am trying to combine .  Does anyone know if this can be done?  I got a
result with the following:
=PERCENTILE(SUMPRODUCT((C1:C10="Green")+(E1:E10="Cat")),0.9)
=SUMPRODUCT(--(C1:C10="Green"<PERCENTILE(C1:C10,0.5)),--(E1:E10="Cat"<PERCENTILE(E1:E10,0.95)))

Is there a way to make the CONCATENATE formula put all the text on different
lines?  It keeps combining some on the same lines and I want them all on
separate- like a list.  Thank you for your help!!
LJoe

I need to invert the data in a column.  The column is a mixture of text
numbers and blanks.  Here is a small example in col A
a1:   
a2:    ssn

Can a cell be split so you can put 2 pieces of information in it, like
Pass/Fail?
Thanks

I replied to the following thread: http://tinyurl.com/2ky6vm, but it
was a month old and I've gotten no replies.  Therefore, I am creating
this new post to address the matter.
This has been asked previously, but I have never seen a response that