# or formulas

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### IF and OR

I want to use IF function for =IF(CB3=1 OR BM3>0,Answer1,Answer2). How to accomplish?
8. ### 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. ### 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

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