SpreadsheetWEB
  • Home
  • Pricing
    • Cloud Pricing
    • Server Pricing
  • Applications
    • By Industry
      • Education
      • Insurance
      • Investment
      • Public Sector
      • Startups
    • By Department
      • Finance
      • Human Resources
      • Marketing
      • IT
      • Sales
    • By Type
      • Data Collection
      • Data Visualization
      • Online Calculators
      • Online Reports
      • Mobile Applications
  • Resources
    • Blog
    • Case Studies
    • Data Sheets
    • Demos
    • FAQ
    • Resources
      • Applications
      • Excel Tips & Tricks
      • Excel Formulas
      • Excel Macros
      • Templates
    • Tutorials
    • User Guide
    • Video Tutorials
    • Whitepapers
  • About
    • About Us
    • Contact Us
    • Services
    • Customers
    • Press Releases
  • Try For Free
  • Sign In
Select Page
How to sum by date in Excel without time

How to sum by date in Excel without time

by Ilker | Jul 11, 2018 | Excel Formulas, Excel Tips & Tricks

Excel already has functions like the SUMIF and the SUMIFS for summing data by groups. However; they can’t work if you have date-time values combined. This article shows How to sum by date in Excel without time using SUMPRODUCT and INT functions. Syntax...
How to get the decimal part of numbers in a data set

How to get the decimal part of numbers in a data set

by Ilker | Apr 5, 2018 | Excel Tips & Tricks

Identifying the detail level of values in a data set can be useful for analysis of results. This simple trick can help you separate the decimal values from the numbers for evaluation. Syntax =number – TRUNC(number) (only for positive numbers) =number –...
How to shorten a number and get the integer value

How to shorten a number and get the integer value

by Ilker | Apr 5, 2018 | Excel Tips & Tricks

Do you need to shorten number, but not round them? Need to find the nearest INTeger or TRUNCate numbers in Excel? Yep, Excel has two functions that do exactly that! You can shorten numbers using the TRUNC and INT functions while preserving the original value, without...

Recent Posts

  • How to Add Dynamic Images in Designer Applications
  • Time Tracking
  • Creating Dynamic Lists in Designer Applications
  • Function: SORT
  • Function: UNIQUE
  • How to delete blank rows and columns at the end of worksheets using VBA
  • Function: MATCH
  • Area Chart in Excel
  • Function: INDEX
  • Save SpreadsheetWEB Applications as Home Screen Apps on iOS and Android
  • Facebook
  • Twitter

© 2019 Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use