criteria range

  1. A

    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...
  2. H

    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...
  3. L

    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...
  4. B

    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...
  5. S

    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...
  6. B

    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...
  7. P

    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...
  8. N

    Advanced filter issue

    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...
  9. J

    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...
  10. G

    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...
  11. A

    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...
  12. A

    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
  13. J

    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...
  14. A

    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>...
  15. C

    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...
  16. B

    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?

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top