criteria range

1. Dividing a sumifs() statement by another sumifs() statement - Problem: Second sumifs() not recognizing valid ranges.

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...
2. How to sum vertical data with horizontal criteria?

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...
3. Adjust Sumproduct construction with Dropdowns

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...
4. Double count in SUMPRODUCT formula

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...
5. Copy & Paste when range meets criteria

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...
6. Copying data between worksheets, based on criteria, where columns may change

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...
7. Alternative Method to Editing Criteria Range in SUMIFS() Function

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...
8. Use formula for range and not row

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...
10. Rolling YTD average formula help - criteria range

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...
11. I think it's something simple, but I'm not that smart in VBA terms

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...
12. SUMIFS _ more different criteria from same criteria region

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...
13. Copy certain rows that have a certain value range in a column to a new worksheet

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
14. Excel 2010 VBA Data Validation and Cell fill in

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...
15. Count Non Blank Cells in a range across multiple Worksheets where the same criteria appears multiple times

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>...
16. Return minimum in a table equaling 2 criteria

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...
17. Advanced Filter with Date Criterion Range

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?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back