Sumproduct

OR logic in Sumproduct function in Excel

OR logic in Sumproduct function in Excel Sumproduct usually will be applied with AND logic. OR logic in sumproduct function can be implemented as detailed below. A) AND condition example is as follows: =Sumproduct((A3:A159=B3:B159)*(D3:D159="Target A")) =Sumproduct((A3:A159=B3:B159)*(D3:D159="Target B")) B) There are ways to add OR condition using “+” symbol. The “plus sign” (+) is for OR in...

Count cells that are not blank

Count cells that are not blank Formula to count the cells that are not blank in the range. Using CountA,Sumproduct functions. For blank cell count, countblank function can be used. https://exceljet.net/formula/count-cells-that-are-not-blank

Extract number from string at any position using Excel

Extract number from string at any position using Excel with the huge data sets available, it is required to separate the text and numbers based on the requirement. The following will guide you how to extract number from string, either it is far right or in middle of the string. A) Extract number from...

Published On

December 2018
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31