or formulas

  1. I

    Array SUMIF formula with OR formula condition

    Hello, I have a sumproduct array formula before but it is double counting the two conditions... = SUMPRODUCT(--(RIGHT(I$17:I$17,10) = "(ACCRUALS)"),(H$17:H$17)) + SUMPRODUCT(--(C$17:C$17 = "Dividend Receipt"),--((E$17:E$17 = 0) + (F$17:F$17 = 0)),(H$17:H$17)) Therefore, I am thinking a way to...
  2. N

    Formula help needed

    I need some help here. I've looked everywhere but can't seem to find it. I have a due date in B2 and =TODAY() in A1. I need a formula that says if B2 is <= today then it will say "late" but if B2>today then it will say "" please help. These formulas confuse me big time.
  3. D

    Using sumproduct with nested arrays

    Here's the formula I'm trying to use: =SUMPRODUCT((subscriptionType="premium")*(hasPaymentInfo="Yes")*(payDate>='db analysis'!H$20)*(payDate<='db analysis'!H$21)*(OR(cancelDate="-",cancelDate>H21))) It's not working, I know because I can check by appllying auto filter on the data sheet and...
  4. D

    Using countifs with nested OR statement

    Why doesn't this work! COUNTIFS(DB!$C:$C,"<>"&"",DB!$Q:$Q,OR(DB!$Q:$Q="-",DB!$Q:$Q>Summary!B7),DB!$N:$N,"<="&B7) I want to say select data where:DB!C:C is not blank; DB!Q:Q equals "-" OR is greater than B7; DB!N:N is less than or equal to B7. What is the proper way to nest this OR statement...
  5. D

    Nested or statement

    I'd like to check whether a string of text in a cell contains either "something" or "somethingelse". IF(ISNUMBER(FIND($F$5,D8)),$F$4,0) OR IF(ISNUMBER(FIND($F$6,D8)),$F$4,0) The result should either output the contents of cell F4 if True or 0 otherwise. I've tried a few nestings with no luck...
  6. C

    Formulas in Conditional formatting

    I am trying to build conditional formatting for a report I run daily. There are certain criteria that I want to "pop" out drawing immediate attention. I want build it so that the variables in column O (several) are true column W (several) are true and Column if Blank =AND($O1="BR- PAP New...
  7. H

    IF and OR

    I want to use IF function for =IF(CB3=1 OR BM3>0,Answer1,Answer2). How to accomplish?
  8. J

    Sumproduct - Or help

    Good afternoon, I wondered if somebody could help me with my sumproduct formula please? So far I have: =SUMPRODUCT(((('Request Data'!H1:H6000<=C8)*('Request Data'!H1:H6000>=Weekly!D8)*('Request Data'!L1:L6000="standard")*('Request Data'!G1:G6000="axapro")))) The problem is the last part...
  9. J

    What IF's

    <TABLE style="WIDTH: 428pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=568 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" span=4 width=74><COL...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top