syntax

Hi im using excel 2016 i am having problems with my formula '=COUNTIFS(full_extract!E:E,full_extract!G:G"1",A1) count value from sheet column E:E, when column G=1 against the data in A1.. i get a syntax error thankyou

Hello and thank you in advance if you can help, I am trying to create a column in a query that compiles/concatenates information from other columns when certain criteria are met. The problem I am encountering is how to put it in terms of Concatenate IIf, or if that is even valid syntax within...

I only want to apply the ROUNDUP function when N8<O8, otherwise return N8. This formula returns N8 regardless, even if I swap the < for >. Can someone help with the correct syntax? =IF(N8<O8,ROUNDUP((O4*N5),0),N8)

I need some help with some vba syntax. I have part of a procedure that opens another workbook, performs some actions then closes it. This is the code I have: Workbooks.Open (ThisWorkbook.Path & "\" & DocYearName) All the workbooks are stored in the same folder and the variable DocYearName...

I found a new handy function that allows me to write a formula that keeps the sheet name of the formula dynamic. It's pretty cool except that I barely understand how it works! So I have a formula that looks like this: =VLOOKUP(B3,'[2019 BOB Goal Calculation.xlsx]2019'!$C$8:$D$20,2,0) I would...

In A Double-Click Event Macro I'm Having Syntax issues in getting the 2nd code line to "take" Lr = Range("C" & Rows.Count).End(xlUp).Row If Not Intersect(Target, Range("N & Target.Row & ":P" & LR)) Is Nothing Then What's the proper syntax? TIA, Jim

Hi I am helping my local historical society in a voluntary capacity to get their website on line. It will contain a catalogue of 400-500 documents. I have a list of them which I can get into excel. In excel they appear as: column 1, a code for where they are in the filing cabinets, eg...

Is the following fixable? =OFFSET(INDIRECT(" ' "&My Main&" '!"&"$A$2"),0,0,COUNTA(Main!$A:$A)-1,1)

I want to use: =COUNTIF(January!B7:B37,summary!A12) except I want to have the sheet name 'January' taken from a cell so I can perform the countif on a large number of sheets Is there a syntax which allows January!B7:B37 to be replaced with "A1"!B7:B37 in a formula where A1 contains January...

Hi, I am very new to VBA, hence the question is quite basic. However, after browsing forums, i could not tackle it myself. I was doing some modifications to the below part of a SUB. It extracts information from one sheet as per the first row and should make the ''desired output''. I have the...

I am trying to test a cell ad see if it is blank and if it is return a blank the target cell. If it isnt blank I want the rest of the statement to run. My syntax is wrong somewhere..... IF(C4 = "","",(OR(AND(TODAY() <> E4,F4="Complete"),AND(TODAY() < E4,F4="In...

I can seem to get the formula syntax to get this right IF (A1 <>"" and B1<>"" and C1<>"") Then "Bronze" IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"") Then "Silver" IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"" and F1<>"" and G1<>"") Then "Gold"

Hello How can i incorporate the Range syntax into Cell syntax Private Sub CmbBooks_click() Dim idx As Long idx = CmbBooks.ListIndex If idx <> -1 Then ws.Range("B" & idx +2 ).Value End If End sub incorporating from above code into below seems not working Dim idx As Long idx =...

Hello =IF(BE3<$A$1,BF3,0)+IF(BJ3<$A$1,BK3,0)+IF(BO3<$B$2,BP3,0)+IF(BT3<$A$1,BU3,0)+IF(BY3<$A$1,BZ3,0) Got stuck in writing the syntax for above with IF formula curRow = 3 ws.Cells(curRow, 83).Formula = "=IF(BE" & curRow & "<a1," &="" "bf,"="" "0)" Thanks NimishK</a1,">

Hello and thank you for any attention my post may receive. My goal is to have multiple cascading combo boxes, and I have succeeded with the first two. I receive a syntax error with the third. In my first code below, cboMake populates as it should after cboUnit is updated. However the second...

I'm wondering if someone can point me in the direction of a resource that describes the syntax of different combinations of ranges like below. I have trouble remembering the right syntax for concatenating the different items, and I'd just like to bookmark a page that has examples of these types...

In my worksheet I have continuous rows with data in D7:D726. I column E I have data from E7:E24. I need to copy the data in range E7:E24 and autofill the remaining rows in col E (i.e. E25:E726) with that range of values. The ranges in both col D and the initial range to be copied in col E...

Hello forum guys. I want to know what is the way of referencing worksheet within the GetObject function. I know there are other ways of refering. On the MSDN documentation there is example of referencing the class and object with the syntax like this. Set LayerObject =...

I am getting following error Getting Application Defined or object defined error in syntax below ws.Cells(1, 3).Formula = "=(ws.Cells(1, 1).value) * (ws.Cells(1, 2).value)" Pl dont show any .formula with range thanks NimishK

Afternoon Can someone assist with the correct syntax for the below countif :confused: cell(1,12).formula ="=countif(G1:G100),"<=10000")