Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 54 of 60 · 540 articles
Case Sensitive Count
Learn about case Sensitive Count in Excel, including the relevant formula or feature, setup steps, and practical usage.
How to calculate average of values with OR operator
If you want to handle AVERAGE OR combination, AVERAGEIFS function will not work. This article shows how to calculate AVERAGE OR with multiple criteria using the SUMPRODUCT function.
How to sum values with OR operator using SUMPRODUCT with multiple criteria
Learn how to sum values with OR operator using SUMPRODUCT with multiple criteria. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to count values with OR operator
Learn how to count values with OR operator. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to calculate Least Common Multiple
Learn how to calculate Least Common Multiple. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to calculate Greatest Common Divisor (GCD)
Learn how to calculate Greatest Common Divisor (GCD). This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Windows Character Set (1252)
Learn about windows Character Set (1252) in Excel, including the relevant formula or feature, setup steps, and practical usage.
MAC OS Character Set
Learn about mAC OS Character Set in Excel, including the relevant formula or feature, setup steps, and practical usage.
How to calculate AVERAGE with intersecting tables
Learn how to calculate AVERAGE with intersecting tables. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.