SUMIFS – XLf(x)s

Count cells with condition – multiple conditions

Posted on February 16, 2018February 16, 2018 by ANmar

We did see who we can get total of a column for a certain month in certain year using SUMIFS. SUMIFS got a sister function, COUNTIFS Which will count how many times cells found with more than 1 condition So, when you have a table like this…

Get monthly total from table with dates

Posted on December 26, 2017 by ANmar

Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded interesting in getting this example Here is an example on how to calculate total amounts of dollars per month (and number of days) from a table with dates The tricky […]

Bootstrap 4 WordPress Theme | Theme Name: WP Bootstrap 4.