1. ibmy

    Sum of Negative or Positive, Exclude 0 or Include 0

    Hi Excel Experts 🥇 Sample of 20k row data I face weekday : BCDEF1Sum of Negative Sum of Positive2ValueExclude 0Include 0Exclude 0Include...
  2. O

    Return cells only containing certain letters

    Here’s my scenario: I have a list of words and a list of letters. I want to return the words that contain letters from the list of letters and ONLY from the list of letters. For example: WORDS: cog, bib, ab, back, cab LETTERS: A, B, C WORDS returned: ab, cab Thoughts?
  3. T

    Pivot table to exclude a row

    Hello, I have a table that looks like the following: Country Element AA 11 BB 22 CC 33 Now, I want to pivot that table to show me the sum of "Element", BUT Country "CC" has to be excluded from the sum (and shown separately in the same pivot table). I created a calculated field defined...
  4. S

    Exclude a specific value from drop down list

    I have a table where I have staff names. I use these staff name to create down down list using INDIRECT formula and it works perfectly. Now I want to create a new drop down list, but want to exclude few specific staff name and show rest of the staff names. I using below formula but I get an...
  5. D

    Set Due Date/Time using DateAdd exclude weekend and holiday

    Hello, Need help, i use DateAdd function in my Query, DateAdd("d",numberofdays,StartDate), however i need to exclude the weekend and holidays. Can you guide me on how i can do that. Thanks Regards, Den
  6. A

    Resource Planning

    Hi, I've got a resource plan spreadsheet and its functioning fine, but i was wondering if anyone can suggest how i can get it to exclude weekends and holidays. my forumula is: =SUMIFS(Table1[[Hours/Day]:[Hours/Day]],Table1[[Resource Name]:[Resource Name]],Report!$B17,Table1[[Start Date]:[Start...
  7. muhammad susanto

    Average With Exclude Text,Blank Cell, Zero Number

    hi all.. how to make average formula exclude 3 criteria text, blank cell, zero (0) =IF(COUNT(H8:T8);AVERAGE(H8:T8);"") but still not fully working thanks in advance.. .sst
  8. J

    Average last 5 non-blank cells

    <tbody> 1 1 0 1 1 0 </tbody> Hello there, My goal is to get the 60.00% but what formula would I use to exclude blanks and only consider the bottom 5 values? Thanks!
  9. E

    VBA to Copy Range from Muliple Worksheets in one master

    Hi All, I am hoping someone can help. I have a spread sheet with 30+ tabs and I want to copy certain named tabs for the same range on each selected tab into 1 master sheet. The below works if I have only 1 to exclude but I have multiple to exclude . how do I amend to either include 20+ sheets...
  10. P

    IF "x" is within all columns

    I'm looking for a formula to put in 100 rows to tell me if "exclude" is populated in any of the 250 columns. If yes, then "exclude included" If no, then "Exclude not included" Any ideas?
  11. A

    Dynamic Named Range exclude last row

    Hi all, I have a data set as follows: Data Headers A1: U1 Data: A2:U395 The number of rows in the data changes every month, and so I have a dynamic named range I want to use (formula below) which exclude the last non-blank cell in the column. The problem is I need to apply it to the whole...
  12. L

    adding text to two different cells and highlighting row

    Hello, Can someone please help me with this? I am using a Dim statement in VBA but would like to expand my text to the next column over. Here's what I have so far: Sub CommercialMarketPlace() ActiveSheet.Select Dim a As Long For a = 1 To Cells(Rows.Count, "S").End(xlUp).Row If Range("S" &...
  13. C

    Skipping Specific Row Within a Loop

    Good day all, I have a quick question: I am running a loop which copies certain cells from rows according to an IF statement from a different worksheet. My code runs from i = 9 to i = 61 but I need it to ignore row 21, as it meets the IF condition yet I still want it to be ignored, how would I...
  14. C

    Graph exclude blank months at end of year

    I have a graph of calls for each month. Jan to Dec Along the year, say in June, I'd have blanks for July to Dec. I'd like the graph to only show months with data, ie Jan to Jun. and not include empty space for the last 6 months. I've searched and found how to exclude blank dates between...
  15. R

    How to add a condition to COUNTIFS formula to exclude certain numbers?

    Hello, I have a COUNTIFS formula [=COUNTIFS(B2:I2,"<70")] that calculates the number of times a score is less than 70, as follows: <tbody> Dates 3/4/2019 3/11/2019 3/18/2019 3/25/2019 4/1/2019 4/8/2019 4/15/2019 etc. Student1 71 68 78 92 79 96 73 etc. Student2 56 71 68 75 70 81 77...
  16. T

    VBA dynamically exclude value in filter

    I was wondering if anybody can tell me how to exclude a specific value from a filter after I run my macro. I have the code at the end so it runs last however I am needing to always exclude 0 and #N/A from the output. I cannot tell it what values to include because they change with every run of...
  17. P

    Rank - exclude subtotals

    How do I setup a rank, type formula, to exclude subtotals? I am trying to pull a top 10 list. if I do a subtotal on the original data, I lose most of my top 10 values.
  18. G

    count cells that string contains X but does not contains Y or Z

    Hi, sooo..... I have list in table 1 (below) and I want to count in table 2, the number times the text in table 2 column A appear in the list from table 1. BUT i need to to exclude any entries that are in A4 or A5 from table2. I can do count if but i cant figure out how to exclude. for the...
  19. R

    COUNTIF with exclusions

    Hello. I'd like to count a range of cells that contain any text using the formula: =COUNTIF(H11:H64, "*") Problem is that it’s counting all of my cells since they each contain an IF statement. How do I exclude cells that contain an IF statement that output blank? For example, here’s what one...
  20. S

    SumProduct if A=ABC and to exclude B = 123

    hey guys, would apreciate some help What would be the formula, to do the following logic? To sum the values in Column U, but only if Column A = B1(same data as the value in cell B1) and Column B= C1 but exclude if Column D= E1and Column E=F1 thanks in advance

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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