I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this?

What is the correct formula for extracting data from a pivot table report which meets a certain conditional set of criteria?

for my thesis i need to create median industry multipliers. i have a list of companies with their industry codes and multiples, but now i need to create a list...

I have an old database that stored it's data in a sequencial format with fixed lengths for each field. As Windows 7 64-bit no longer allows the running of...

Can someone help me with the following statement: =AVERAGEIFS(BeezidTable,BeezidTable,"TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))") It returns DIV/0, but...

How do we calculate equated monthly installment value for given int rate and period for a capital available and reverse of the same. Thanks

Need a formaula to look at an entire column and count the number of different times (say date of product) Thanks -- ce

-- John

Im working on a colum that is a medical schedule for Doctor who will be working that day so that I know how many exam rooms will be needed - right now Im...

Cell DQ contains a formula that pulls in the status of the item. Here is my existing formula so...

In column A I have set of characters that are entered into the rows below (i.e. Y, N, MRO) in column B I have another set of characters that are entered into...

I have 3 cells I need to merge into one. One of the cells is a number anywhere from 1-16 or more. What I need is for the number in this cells to always be...

When I take a Banner database exported to excel and save it as .dbf file to use in mailing software, it drops certain fields in the name field. Does anyone...

I've never seen this error before, and unfortunately, my Google searches keep bogging me down with the simple "Automatic/Manual" solution... I have Workbook...

customize toolbar , all commands, barecode cammand, after barecode command has been placed in toolbar, it has not funtion, i am unable to click on it , under...

I have columns numbered for payments. A PO can have any number of payments. A PO can be shown on any number of rows as the resource being billed against the...

Please help! I am trying to get the formula below to return a value to the cell ONLY if the answer to ((c30-$30)/g$30) is greater or less than 20%. I am...

I have a file that was 8MB when I started. I created a pivot table pulling 7 fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot...

This is my first question on this site, so I hope I hope this makes sense. I have vendor numbers in Col A-each vendor number would only be listed one time...

I have a report download that roughly looks like this: Part # Date Qty 1234 6/1/10 25 1234 6/3/10 50 1234 6/7/10 100 4567 6/1/10 ...