December 20, 2015
Excel Magic Trick 1184
DESCRIPTION See how to… Create a formula To Create A List of Dates For Month. Change the start date and the list updates. See the functions, EOMONTH, DAY, IF, ROWS. WORKBOOKS
DESCRIPTION Topics in this video: (00:34) AND Criteria for SUMIFS, COUNTIFS, AVERAGEIFS (05:18) DSUM (07:53) SUMIFS with 3 criteria. (10:36) Use COUNTIFS or COUNTIF for 1 condition? (12:35) Use SUMIFS or SUMTIF for 1 condition? […]
DESCRIPTION See how to add unit numbers with AND and OR Criteria where the criteria are given as years and months but date column contains serial number dates. See how to use SUMIFS function to […]
You must be logged in to post a comment.