Recover Countersignature Formula with airSlate SignNow

Recover countersignature formula

welcome to XL matric number 575 hey if you want to download this workbook and follow along click on my youtube channel then click on my college website link and you can download the workbook SLI district 5 75 25 78a in this video here we want to do something we have done in other videos but do it together I want to count with three criteria here's the three criteria and I want to count how many records there are that meet that criterion then when you want to add conditional formatting with three criteria so only one the record meets all three criteria do we want it conditionally format it now i'm going to count two ways if you have 2007 you definitely want to use countifs they are the fastest calculating amongst all of the options now one two three so we have the criteria range click their control shift down arrow f4 just to jump it back up there comma and the criteria right there criteria one I love the way these screen tips work compared to say some ifs and earlier versions or count if they actually say criteria one criteria to etc the second range control shift down arrow f 4 comma get this one for the criteria comma click ctrl shift down f4 and now comma since we have a 200 here we're going to need this 200 in the conditional formatting I'm not going to put greater than here I'm actually going to code it right in here so the criteria would be in quotes greater than and double quote in ampersand shift 7 to join those two things together so there's the criteria there's only one if I hit f9 now there's three now in earlier versions you don't have count if so you do some product and we're going to have three arrays that are going to be filled with trues and falses and we need to convert the trues and falses to ones and zeros so we use double- always converts true 21 and 0 to false 20 click their control shift down our f 4 equal so in count ifs you type a common do the criteria here you have to you say is that equal to this close parenthesis that's the first array comma double negative open parenthesis ctrl shift down arrow f4 again you don't need the f4 I'm just jumping it back there and again you say equals and it's going to create some trues and falses comma double negative open parenthesis ctrl shift down arrow f4 now here we just need to put our comparative operator just like the comparative operator was equal equal we just see greater than and then click right there close parentheses close parentheses the sum-product will take the ones and zeros ones and zeros 10 is multiplying only when you get a 1 1 1 will some product multiplied together get a 1 for that particular record alright so...