In this post I will show you the trick to make the function SUMPRODUCTIF. We have SUMPRODUCT fuction in excel. But how to make a SUMPRODUCT fuction that follows criteria like SUMIF. Here I have made an example. Here’s how…

Here I will share a general tips about Conditional Formatting and some Information functions. These functions are ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT. You can use these functions to highlight specified type of values among an array. ISBLANK function highlights blank cells among an array of values.…

Tagged with: CONDITIONAL FORMATTING

Top