Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Multiple lines in cell using functions CHAR
  • IF with AND and IF with OR AND
  • Excel @ before function names in formulas Excel User tips
  • Sort list dynamically (functions) COLUMN
  • CTRL+Y a mini macro Excel User tips
  • Unix DateTime Number Basic Math
  • CountIf limitation COUNTIF
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips

Category: SUMIFS

Count cells with condition – multiple conditions

Posted on February 16, 2018 By ANmar
Count cells with condition – multiple conditions

We did see who we can get total of a column for a certain month in certain year using SUMIFS.

SUMIFS got a sister function, COUNTIFS

Which will count how many times cells found with more than 1 condition

So, when you have a table like this…

Read More “Count cells with condition – multiple conditions” »

COUNTIFS, Formulas - combined functions, Math and Trig, Statistical, SUMIFS

Get monthly total from table with dates

Posted on December 26, 2017 By ANmar
Get monthly total from table with dates

Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded interesting in getting this example Here is an example on how to calculate total amounts of dollars per month (and number of days) from a table with dates The tricky…

Read More “Get monthly total from table with dates” »

DATE, MONTH, SUMIF, SUMIFS, YEAR

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Worksheet name, dynamically using formula CELL
  • Skills Grid Conditional Formatting
  • Return 12 values in one number AND
  • VLookup Lookup and References
  • Tally chart in functions Formulas - combined functions
  • Min Max vehicle Formulas - combined functions
  • MID + SEARCH to convert cell to rows MID
  • Scorring, saving multiple outputs in 1 number Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme