ifstatement

The following formula works fine... =COUNTIFS(R30:DH30,">"&(MEDIAN(R30:DH30))) This formula works fine as long as you Ctrl+Shift+Enter =COUNTIFS(R2:DH2,">"&MEDIAN(IF((R2:DH2>0),R2:DH2))) The formula below doesn't error out but it reports zero (this is not true when you look at the data). How...

Hi I am trying to calculate when data is out of hours based on it being before 08:00 and after 16:30, plus also weekends. I have used the following formula to calculate the day of the week. =TEXT(WEEKDAY(AE2), "dddd") I have this in a seperate column. This is how my sheet looks. <TABLE...

I'm trying to say average each amount in column AV that has a corresponding date after 3/1/2011 in row F. The formula I'm using is: =AVERAGEIF('Unit Renovation Roll Up'!$F$299:$F$368,">3/1/2011",'Unit Renovation Roll Up'!$AV$5:$AV$368) What am I doing wrong?

Hi Guys I need help with a formula Basically Im creating a stock spreadsheet for work that will track outgoing parts each month. I've the total values sorted for the month, however Im having problems breaking the totals down so that each individual PO is tracked. As you can see below I have...

Hi All, I need a formula that lets me do the following: I have a cell (A) that will have a number between 1 and 25. If the number is 1 or more but less than 9 then I want cell 'B' to =G(As in the letter not the column), if the cell is 9 or more but less than 20 I want cell 'B' to =A (As in...

Hello Just having a little trouble with syntax. Just need to do this: "If the month in date cell in col G is the same month as shown in cell M1, Then (proceed)" It's got an OFFSET because it is running through rows in a table and checking two conditions. Here's the For and If statement...

:( This is just mean - my whole post disappeared! :banghead: :eek2: Ok, one more try... I'm having a bit of trouble with date and time. Let's say my sheet looks like this: I want to calculate the intermediate hours, thus between one given date/time (the time belongs to the date above)...

I have a question on how to stop a macro from executing if a cell is TRUE? I'll have a check box for the user to select to make the form permanent. So, when re-opening the form at a later time; the date, time and autonumber will not automatically change. I'm sure this must be possible, but I...

im trying to make a formula that will do this :confused: if i put in the name "joe snuffy" it returns 220 if i put in the name "gilligan snuffy" it returns 350 if the cell is blank it returns 0 if any other name is put in the cell it returns 40

I've created an invoice form which uses the Invoice number to return the results, there are multiples of the same number, say there could be 4 different lines using invoice number 72. So far I've created my vlookup fields as (First line) =VLOOKUP(E4,'Invoice Sheet'!A:M,3,0) and then...