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

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
Top