Get
Digital
Help
More
  • Home
  • Functions
    Functions A to Z Functions by category
  • Formulas
  • Features
    Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down lists Named Ranges Solver
  • Charts
  • Conditional formatting
  • Pivot table
  • VBA
    VBA Functions Methods Properties Statements Macros User defined functions Files & folders Checkboxes
  • Archive
    All articles
  • Contact
    About me Blogs I read
    Formula categories
    #
    2D
    3D
    365
    Address
    Advanced Filter
    Alternative
    And logic
    Autofilter
    Average
    Blank
    Calendar
    Case
    Character
    Column
    Combination
    Complex
    Concatenate
    Conditional formatting
    Count
    Countif
    Countifs
    Criteria
    Date
    Day
    Decimal
    Delete
    Digit
    Duplicates
    Dynamic
    Empty
    Equal
    Error
    Extend
    Extract
    Finance
    First
    Group
    Hour
    Hyperlink
    If
    Ifs
    Ignore
    Image
    Index
    Index match
    Intersection
    Lambda
    Large
    Letter
    Lookup
    Match
    Max
    Min
    Minute
    Month
    Multiply
    Negative
    New line
    Not equal
    Or logic
    Overlapping
    Partial
    Permut
    Random
    Rearrange
    Record
    Recursive
    Reference
    Relation
    Reverse
    Right
    Running total
    Schedule
    Second
    Sequence
    Shared
    Small
    Solver
    Sort
    Split
    String
    Substitute
    Subtotal
    Sum
    Sumif
    Sumifs
    Sumproduct
    Tab
    Table
    Team
    Text
    Time
    Unique
    Vlookup
    Week
    Year



'Find numbers in sum' category



test
How to do tiered calculations in one formula
The image above demonstrates a formula that calculates tiered values based on a tier table and returns a total. This […]
test
Find numbers closest to sum
Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]
test
Identify numbers in sum using Excel solver
  Table of Contents Identify numbers in sum using Excel solver Find numbers in sum - UDF Find positive and […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories


Home page
Excel Functions
Excel Formulas
Excel Tables
Advanced Filter
Data Validation
Drop Down List
Named Ranges
Excel Solver
Charts
Conditonal Formatting
Pivot Tables
VBA
Macros
UDFs
Archive

  • Search website

No AI