Excel’s SUMIF function

Here is another classic situation: I have an Excel file with two data column. First column contains list of numeric values, and the second column contains labels. Now I would like to sum all the cells in the first column that their second column has the value “Yes”. Something like in the screen below: Excel ...

Excel’s COUNTIF Criteria Argument

Here is a classic situation: I have an Excel file with data column, the data column holds multiple strings. Let’s say something like in the table below: If my goal was to count the number of rows that has the exact value of “Money” then the function was simple: =COUNTIF(A:A,\"Money\") And the value in the ...