KCR Learning Solutions

KCR Learning Solutions

Learning solutions for around the office

  • Home
  • Courses
  • Dashboard
  • Notifications
  • Sign In

EMT1097 AND & OR Criteria Together for Counting, Adding, Conditional Formatting

April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged AND, Conditional Formatting, COUNTIFS, OR, SUMIFS, SUMPRODUCTLeave a Comment on EMT1097 AND & OR Criteria Together for Counting, Adding, Conditional Formatting

…

View Article

EMT1089 Month, Year To Date and Variances with SUMIFS

April 12, 2019April 22, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged Advanced Filter, GETPIVOTDATA, SUMIFSLeave a Comment on EMT1089 Month, Year To Date and Variances with SUMIFS

…

View Article

EMT1083 Add Invoice Amounts Between Start & End Dates

April 10, 2019April 22, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged SUMIFSLeave a Comment on EMT1083 Add Invoice Amounts Between Start & End Dates

…

View Article

Popular Topics

Advanced Filter AND Array Formula COLUMN Conditional Formatting COUNT COUNTA COUNTIF COUNTIFS Database DATE GETPIVOTDATA IF INDEX INDIRECT ISEVEN ISNA ISNUMBER ISODD LEFT LOOKUP Macro MATCH MEDIAN MID MIN MMULT MOD MODE MONTH NOT OFFSET OR PowerPivot ROW ROWS SEARCH SUBSTITUTE SUM SUMIF SUMIFS SUMPRODUCT TEXT VBA VLOOKUP

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

My Tweets
KCR Learning Solutions
Don`t copy text!