include

Hi there. I have this formula {=AVERAGE(IF(Data!B:B=G6,Data!L:L))} but its including the blank cells in the average calculation. My question is , is there something i can include to ignore these blank cells? Many thanks in advance

I have the following code building charts, but am stumped as to how to successfully include a secondary y axis. the hasaxis properties don't seem to be including a secondary axis With ch .HasTitle = True .ChartTitle.Text = aa & StartDate & " to " & EndDate...

Get a debug in the clear property Sub RCInclude2() Dim Cl As Range For Each Cl In Range("J2", Range("J" & Rows.Count).End(xlUp)) If InStr(1, Cl.Value, "Include", 1) > 0 Then Cl.Offset(, -2).Value.Clear end if end sub

Hi all I've managed to cobble together some code (I'm new to this!) to create a CSV from a formulated tab in a spreadsheet. This new csv should be called the name of the tab plus today's date. It will then prompt the user as to where to save this csv. It all works fine apart from 3 small...

Hi – I have a table which previously counted 2 vairables– however now I need to include a 3rd variable – the month. I.e. I needto count where Column A=gg and CoulmnB = sd and ColumnC = sept-18 Each wayI have tried returns a 0

Hello, I am new here and not familiar with VBA so i would like some help if possible. I would like to make a list in excel to include all "xlsx" files and its sheets that will find in a specific folder and its subfolders. Until now, i came across to 2 possible solution but both are not...

Hi, I have three columns of data, date, price1, and price2. When I add new rows of data, my pivot table does not include the new rows. I have to check off the new dates in the drop list and then it adds the data to the pivot table. My pivot table data source DOES include blank rows. Any tips to...

Hi all, I am using the following standard sum offset to do a year to date formula, the A3 and V8:AJ8 are just matching the names of the month from a dropdown list and lookup. The formula works fine, but my rows across are: JAN FEB MAR Q1 APR MAY JUNE Q2 JULY AUG SEP Q3 OCT NOV DEC Q4 so the...

I am working on a chart that gives the user the option to include or exclude weekends in the forecasting of a project. Have not been able to write the formula correctly for the option to include the weekends. The design is simple: User places a "x" in a cell on worksheet #1 , if they want...

I am using the following formula to count the number of occurences of a date so long as a value in a corresponding column is >0. =COUNTIFS(Records!$F$2:$F$40000,">=1992-1-1",Records!$F$2:$F$40000,"<1993-1-1",Records!$I$2:$I$40000,">0") This works fine, but I wish to expand the range which...

Hi, I'm wondering if there's an easy/automated way to make multiple strings of data from a large data set. The thing is i would like to use information in another cell to determine when a new string should be created. The issue that I'm having is coming up with a formula, or logic, to use a...

Good afternoon, I have a problem... I am hoping someone can help. I have a spread-sheet which contains various codes in Column C (30,40,90,95,99) and value of percentage in Column G. I want to take the values 30, 40 and average all amounts including 0% and I also want to include values 90...

Hi, lets say I have 2 tables the same size on 2 different tabs. Imagine an example: Type, Month 1, month 2, month 3, apple,2,3,4 pear,5,6,7 banana8,9,10 Type, Month 1, month 2, month 3, apple,a,b,c pear,d,e,f banana, g,h,i I would like to add another line to one table (or another in an...

I want to sum certain values in Column H when the following holds true--Column F must <>0 and Column G Must =0. For example, h3=0 and F3>0,te I want to include the value in H3. My formula isn't working. I currently have "=sumifs(h3:h246,F3:F246,>0,g3:G246,=0) but there's an error with the...

I have 3 years of data organized Q Column Row1 January Row2 $ Row 3 $ Row 4 $ =sum(offset(Sheet1:Table 1::$Q$4,0,0,(COUNTA(Sheet1:Table 1::4:<wbr>4,"<>0")−12),1) I am trying to do a rolling total for 12 months which does not...

Currently I am working on a document in google sheets with several tabs. "SS", "Math", "Sci", ... and I have a formula I am working on in a separate tab.... =iferror(if(A2="","",index(SS!D:D,match(A2&$B$1,SS!E:E&SS!G:G,0)))) ^ I am wondering if the "SS!D:D" piece...

Hello! I am trying to do a countif that counts one column (column D) to see if it says "face up" but I only want to include those that are distinct in Column C. Is there a way to write this?

Hello, I am trying to create a rule for capitalizing the correct value of IT assets for accurate accounting and depreciation purposes. Here are the conditions: IF the asset and is a composite asset meaning built from multiple pieces AND/OR: <tbody> Hardware less than $5,000 INCLUDE VALUE...

Hi, I'm creating a LARGE IF array funtion as follows: =LARGE(IF(Master!$B:$B=A1,Master!$F:$F),1) The A1 is a drop down list that is selecting a Category name and then selecting the nth largest number in Col F from 1 - 10. I also want to include an option to look at all rows in Col F so that...

Hi all, New to the forum and couldn't find anything on this one. I have the following basic average formula that I need to add some sort of IF to. =AVERAGE(I3,I8,I13,I21,I27) Goal is to take the above and only include cells that = 100% in cells E8, E13, E21, E27. Basically, I only want...