avail

Hi, I am trying to use Countifs to count non blank cells over 2 columns but only count as 1 if adjacent cell is populated ... If that makes sense. I've tried =COUNTIFS('Sheet1'!$a:$a,"<>",'sheet1'!$B:$B,"<>") to no avail. :( For below the answer I'm hoping for is 4. <tbody> Column ‘A’ Column...

I have a combo box on my user form and I can not find it anywhere. I have used code to move it and make it colors and visible to locate it to no avail. Is there some code to just delete it so I can add a new one? Tired of looking for it. Thanks

Hi, :confused: Confused have put a lot time on below but couldn't find Solved it sadly ;( I have a Senior hopefully might we can Solve below situation with formula. Ever employee has number of Paid laves in his account. But those paid leaves can't be availed all at once. Only allowed or can...

Hi All Im trying to add the ISERROR syntax to the start of this formula in order to eliminate any #values appearing to no avail =IF(AND(L$5>=$C6,L$5<=$D6),$J6,"")*$K12 can anyone assist? thanks

Have too many ifs in my formula. If I trying using IFS the formula doesn't work. Tried usings IFS, and several other combinations but to no avail. Maybe I'm trying to do too much for cell...

I have a table with the following headers. I have the values already listed in the 1st and 3rd row. Need to figure out, how to calculate the 2nd row. <tbody> last YE 3 months 1 year 3 year 5 year 10 years 12/31/2018 3/31/2019 06/30/2018 06/30/2016 06/30/2014 06/30/2010...

I have downloaded some date from a website as an xlsx file and for example the field name is "EBITDA margin (%) Last avail. yr" However if I then add a power query command the field name appears as for example = Table.AddColumn(#"Changed Type3", "EBITDA %", each [#"EBITDA margin (%)#(lf)Last...

=COUNTIF(INDIRECT("$AP19:$AP$9999"&$A$1),"9") =SUMIF(INDIRECT("$AP$19:$AP$9999"&$A$1),"9",$BD$19:$BD$9999) I am using these formulas successfully but now I want to change the 9 to the range of 1:9 I tried several variations of the above, but to no avail. thanks Ironsides

I want to combine two formulas in an IF statement? I have this formula: IF (Data!CX43="False"), then proceed with this array formula: {=IFERROR(INDEX(Table!$C$2:$C$1000,MATCH(1,(Data!CT45=Table!$B$2:$B$1000)*(Data!CN45=Table!$A$2:$A$1000),0)),0)} otherwise return "0". I've googled the "google'...

Win 8.1 (dont ask) / Excel 2016 Hello Excelers, i was hoping someone could point me in the right direction please... i have a colleague who's function screentips do not appear (regardless of whether the option is enabled or not). These are not UDF's, just standard Excel functions. We've tried...

I have tried for days now and searched many forums but to no avail....

hi all,i know this is gonna be simple but i'm turning myself in circles here,so thought i'd throw myselfto the mercy of the forumi have a basic tale of data that will change daily (its made up of 2 sets of rankings)4 8 4 3 4 7 4 46 6 6 2 6 5 6 18 4 8 3 8 5 8 15 5 5 2 5 7 5 17 8 7 2 7 5 7 13 5 3...

I have a pretty basic need, but I'm not sure ISBLANK is what I want. I have a column with either blank cells, or dates/times. I want the preceding column to show a 0 for the blank cells & a 1 for the populated cells. I've tried this: =IF(D2="blank",0,IF(D2="not blank",1)) to no avail. I'm...