multiple arguments

Can someone please help me with creating a formula which can take the average from a table, based on multiple criteria in both the rows and columns? My first table is rather large but this is the basic layout : <tbody> Time period : 1 1 1 2 2 2 3 3 3 Week number : 10 11 12 13 14 15 16...

Hi, I've got a worksheet called 'data sheet' where: column W contains amounts of money column A contains "TRUE" and "FALSE" results column H contains dates I want to SUM all the payments in column W which also have a value of "TRUE" in column A, AND which fall within a specificed date range...

Good Morning All, I'm trying to make a macro that links an excel list of meetings with an outlook calendar. I have created a macro so far that is able to create the entries and check to see if the entry exists by a specific date (which doesn't allow for any flexibility). I now need to make it...

hi Folks, thanks for taking a look at this for me. Here is what I would like help with. I have a column of data that I need to have the following applied to if the number is less than or equal to 400, then add 20 to it. If the number is greater than 400 and less than or equal to 1499 then...

hello everybody, (my first post, have mercy!) i've asked my students to create a simple pattern in excel: given a starting ammount of money (c), a rate of interest (i) and a certain number of years (n), they have to find the final ammount after compounding them year per year (it's a basic...

Hello, So I have been trying to get this Array formula to work with multiple possibilities: =INDEX(tbl, SMALL(IF((INDEX(tbl, , $P$3, 1)<=$P$2)*(INDEX(tbl, , $P$3, 1)>=$P$1), ROW(tbl)-MIN(ROW(tbl))+1, ""), ROWS(T3:$T$3)), , 1) There are 2 ways I have tried to make this work with the "OR"...

Hi I've created a food journal and I want certain words to highlight in red that are junk food. So far, I've been creating them individually, but would rather do one long condition to include all the text words that I want. So if the cell value is = milk, soda, fries, pizza, beer, chips...

I'm having trouble using wildcards for text in index/match multiple criteria; I need to find the nearest site along a river (x) below a certain point (distance =21), each stretch of the river is labelled with the streches downstream (so stretch abc is upstream of ab). My problem arises when the...

Hello, I have the following two columns in A1:B4 (customer # followed by percentage) 1 0.5 2 0.9 3 0.8 4 #DIV/0! In column D i have a list of the customer #s. In column E i try to identify if the customer in column D have a percentage >=.8. I am using the below formula, but...

I have a summary with dropdown boxes and accodring to the selection I make, the table changes since I have put SUMIF formulas. I have created a chart that reads the data that is filtered and the chart is modified automatically. Now, the summary is just a summary of multiple projects that...

I have a column as named particulars below and my requirements are in columns ahead...plz someone can give me a solution.. Would be grateful…thanks in advance. <tbody> Particulars Look up fields from the column 1 End result required for individual look up...

Can anyone suggest a fix to my function. Combination average functions and hot to get rid of the #DIV/O! error. This is what I have so far and still does't work...

Hello to all, I cant seem to rack my brain around how to go about making a formula in order to achieve my desired effect using the IF Formula. The data is as follows: Worker Status % S1 75% and higher S2 42.8571% -74.9999% SH...

Hi all, so here's the problem. I have an excel sheet with multiple columns. In one column I have X's and in another I have a limit. I need to look down the stuff column, find every X, match each X to its corresponding limit and then compare all the limits and return only the smallest limit...

<tbody> Deal ID Sales Rep Quarter Value Product <tbody> 0087060 </tbody> Fred Blogs 4 1.000 bread <tbody> 0087060 </tbody> Fred Blogs 4 20.000 butter <tbody> 0087061 </tbody> Fred Blogs 3 45.000 bread <tbody> 0087763 </tbody> John Smith 4 30.000 bread <tbody>...

Hey guys, let me start off by saying that you lot, are GENIUSES. This forum has saved my *** so many times and has really helped me learn alot about excel. Today, i have a new challenge. One that I'm really not sure how to deal with. I have a dynamic set of data, loaded from a server. The...

Hello, I have come close to what I need but need help on the last bit. I hope someone can please help me solve this. I need to produce a gantt chart for batch jobs that run multiple times a day and show that out for a week. So job1 will have multiple rows for each start and end time for each...

Hi, i have a spreadsheet which contains information about booked appointments, for up to six officers. I now need to build a 2 weekly diary summary sheet. I need to match the officer against their appointments for the day. So, Monday would list underneath up to four names of clients booked...

I need to take data from several cells on a form-type worksheet and have it copied to another cell and/or word document in a paragraph-ish format. For instance: <tbody> Caller Name John Doe Caller Type Pharmacist Reason for Call Needs information required to fill prescriptions...

https://www.dropbox.com/sh/swp4v4fhdik3sf2/W2hUtRU3Vh Above is the Dropbox link to my question. Below is a list of all questions, and IF(THEN statements. If the cell to the top left that currently says "Question 1" reads a certain question, the box changes from FALSE to the Question. The...