criteria range

Hi, I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error...

I'm stumped on how to automatically sum data from a rolling report. The report I'm using is pre-set and only comes back in 1 format, with the criteria I need to use across the top with my sales cascading below. I want this to automatically calculate last week's total sales whenever I put the...

Hi all Is there a way to construct an AND & OR sumproduct lookup that uses Tickboxes alongside a criteria range and also a toogle to state which of the list should be used as an OR or an AND criteria to adjust the outcome...

Hi. There are two questions inherent to this thread. But let's go step-wise: I have this formula in which I want to sum items (Description) that contains ANY of the strings in the C16 to C17 range: = SUMPRODUCT( SUMIFS(Value; Description; "*"& C16:C17 &"*") ) This formula however, double...

Hi Guys, I hope you are all well. I was just wondering if anyone would know how I can amend the below code so that it will only copy rows where the value in column D exceeds a Value of 0 any help would be greatly appreciated Many thanks jamie...

Hi guys, I'm hoping someone can help me with this - it should be fairly simple but I'm quite new to VBA and struggling. I've found answers to similar questions on the site, but not quite the solution I'm looking for. I basically have a master report that is produced monthly and pasted into a...

Hello, In its basic form, I have a Text_Cell and then a separate Table consisting of numbers in Column1, text in Column2, and other columns of data which is why I am currently using a SUMIFS() function. What I want to do is sum the values of Column1 based off of multiple conditions in the...

I got this great formula from Exceluser.com (thank you Charley Kyd) to do multi search criteria. Sheet1 <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 97px"> <col style="WIDTH: 64px"></colgroup> <tbody> B C 1 jerry paul FALSE 2 rand grere FALSE...

Hi all, I've been using advanced filter with criteria range for quite long now but lately I noticed something which I am not sure if it's a bug or not. Please check the example belowe, I have the 1st column which I need to filter (column on the left) and the criteria range column (column on...

i have this formula which works to give me an average for an individual week (A3): =IFERROR(AVERAGEIFS(wkly_recap_data_new!$P:$P,wkly_recap_data_new!$AF:$AF,A3,wkly_recap_data_new!$B:$B,A$1,wkly_recap_data_new!$AG:$AG,""),NA()) in the next column i want to get a rolling YTD average, so as i run...

Hello again This is my second post trying to resolve this issue, hopefully I explain it better this time and can get some help. I'm trying to filter on certain criteria for my pivot table and want to reference a particular set of cells. Here is the code I got when I recorded my macro and...

Hello Thing i would like to do in excel is this .. I have a table with various numbers column and in another column are parameters describing these numbers. I want to sum all numbers which meet the required criteria .. something like this <tbody> numbers parameter 5 B 2 B 5 A...

Hi, Could you please help me with a VBA code that would look at column M in sheet 1 and if any cells in column M =>10,000,000 then this entire row gets copied on another worksheet. Thanks so much for your help. Ambarish

Hello all, I have a workbook that contains two worksheets, RawData & Filtered. I have schedules listed by day, building, and duty on RawData and on my Filtered sheet I select Day and Building ($A$9 & $B$9) and have it populate who works for a particular selected day and selected...

Does anyone want to have a crack at this one?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have 4 Worksheets of Data<o:p></o:p> <o:p> </o:p> In each of the 4 Worksheet Column “A” Contains a Product Code (e.g. Cell A3=”XXXX”)<o:p></o:p>...

I need to return the minimum quantity for a part number where the last purchase date is no greater than 2 years from today. The list of parts that will need to be looked up agains the below list will be on another tab. For example, if I needed to know the Min qty to take place in the last 2...

I"m trying to create a criteria range for an Excel advanced filter that uses a date combined with an > = operator. is there a way to use a >= operator in front of the formula that derives the date?