excel fomula

Hello, Apologies is this is a silly question... but can the criteria in a SUMIF() be a range of values? For example I have: =SUMIF(A1:A100,7000,B1:B100) I have a list of product codes in column A and values in column B - I'm looking for product code 7000. All the 7000's are added up and so I...

I am in need of an Excel formula that looks to see if cells in column A match. If they do, then provide the sum of all of the cells that match in that group in the first cell of that group in the appropriate column (GA = column "G", "FL" = column "I"). You can see the totals in columns G and I...

I am currently using the following formula to calculate how many days have passed since the last actioning date. =DAYS(TODAY(), [@[LAST ACTIONING DATE]]) How can I modify this formula to not return a result in the Actioning Date cell is blank? Thank you for any assistance.

Hello, I have 2 columns with customer numbers, some of the columns have the same account number, I would like to combine the columns then remove all duplicates.

Hi Team, I am new into VBA & Excel formula session Currently, I am working on a VBA project with two columns in below name order Closing the balance after elimination (Values rows) Forecast (needs to be done) If the user selects or chooses Q1, then automatically in my “Forecast” entire row...

Hello, i was trying to see how to add an extra statment to this if statement, =IF(OR(COUNTIF(D20:R37,"<>"&"")>61,COUNTIF(D40:D42,"<>"&"")>0,COUNTIF(D45:D59,"<>"&"")>0,COUNTIF(D62:D76,"<>"&"")>0),"X","") the additional statement i want is that if a cell B33 on sheet "List" is equal to "First"...

Hi All, Really appreciate if anyone can help me on this? To get the formula that I already used =NETWORKDAYS(D5,E5,T_HOLS[HOLIDAY]) + I want the formula can count on my halfday leave that I already capture with H1. Please help me. Thank you.

I have excel sheet where i am fetching stock market data, now it changes colour according to my conditional formatting rules, I want to know how many times in total colour has been changed in 1 particular data range during whole day here below mentioned conditional formatting rule and range is...

I use =MAX(C6:H900)to find the max value in a range. I put that value in K29. Then I try to use =MATCH(K29,C6:H900) to find that value in the range to return the row. MATCH returns #N/A. I checked the type of both K29 and the range and they are both v. If I use =MATCH(K29,K29), a 1 is...

Need help regarding Excel dynamically search based sum of two columns matching from two different tables. I have got this Table of Data Entered One Time G H I 1 Quality Name Warp Weft 2 Stpl.1 150 20 3 Cotton.1 80 60 4 Stpl.2 20 20 5 Cotton.2 60 105 6 Stpl.3 20 40 in Column...

In the following context when I say randomly it means in a random order so every recalculate could move the results around. In this example I am trying to randomly display these 3 colours without duplicating, e.g no red, red, red or red blue red...

Hi guys, I have Created Custom Function with three arguments and all three are range values from two different sheets. the custom function is returning the double values and it is getting placed in the cell correctly, Now the thing is, when i delete or perform other operations in the tool...

Hi, I am looking to be able to extract the value of each cell which has a "p" in the 4th spot of a cell. for example I want to populate a column from the below, r1pp12345 r2p312345 r3pp34125 p3rp12345 I would get a column with r1pp12345 r3pp34125 p3rp12345 Any help would be great thanks Scott

Hi Guys, Have a good day. I have excel file with duplicated part numbers per cell but these part numbers have different revision letter and dates. Now, my problem is, i want to get the unique part number and its latest revision letter and date by using Excel formula. Please help me coz the one...

Can someone explain what each line of code does? I program in C++ as a living, but i haven't learnt VBA. I learn code by explaining code, so please explain. sSheet = InputBox( _ Prompt:="Sheet name or number?", _ Title:="Input Sheet") On Error Resume Next If Val(sSheet) > 0...

Hi All, I need a help where I have the numbers in column B but they are not in the number format. So I want the moment my macro paste the data in column B, it should convert that column in number format. I have tried multiple time but it only paste the data in as usual format. Kindly advise...

Hi, Currently I am computing the date difference in days using this formula (which works): =if(and(ISNUMBER(W2),ISNUMBER(H2)),W2-R2,"") However, I would like to restrain the output and only consider values between 5 and 150. So I would like the function to say If W2 isnumber and if H2...

Looking for a formula to check the first 3 characters of a string and return TRUE if all three are "A-Z only" =IF(ISNUMBER(VALUE(LEFT(J6,3)))=FALSE,TRUE,FALSE) abc123 = true 123abc = false a1b2c3 = false

I am having a problem with my Vlookup formula I am hoping that I can get some help. The formula is on Sheet1 cell Y15. I am trying to do a lookup based on account number on sheet 1 and 2. on Sheet 1 the account number is in Column C the column header is C11. On sheet 2 the account # column is...

I have an equation shown below: ='H:\Business\Excel Data\Weekly Occup Reports-Other Prop\2016\[2016 wkly occup v2_Compute.xls]Jun 19'!$E$10 Instead of using the Jun 19 sheet each time, I need the sheet name to be pulled from Cell A1 on this workbook, so cell A1 would be "Jun 26" next week...