↓ Skip to Main Content

Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Tag: SUBTOTAL

Video Published: Auto numbering formula in Excel | Excel tricks and tips 2021 | Excelabcd

By Puspendu Roy Karmakar Posted on July 11, 2021 Posted in Video Notification Tagged with ROW, SUBTOTAL
Video Published: Auto numbering formula in Excel | Excel tricks and tips 2021 | Excelabcd

Hey friends! I have just published a new video explaining how to make auto numbering formulas that can generate serial numbers automatically. Please watch this video and share it if you like it. Don’t forget to subscribe to the channel Excelabcd.

Lesson#128: Formula to make serial no auto arranged when filtered

By Puspendu Roy Karmakar Posted on January 16, 2019 Posted in Excel Funtions, Excel Tricks Tagged with IF, SUBTOTAL
Lesson#128: Formula to make serial no auto arranged when filtered

Here I will show how to make auto arranged serial no when you filter a column. This post will be very useful to many excel users like me. Suppose you are using a data sheet and you need to filter …

Lesson#128: Formula to make serial no auto arranged when filtered Read more »

Lesson#57: Simple trick to count rows by color

By Puspendu Roy Karmakar Posted on March 3, 2018 Posted in Excel Features, Excel Tricks Tagged with FILTER, SUBTOTAL
Lesson#57: Simple trick to count rows by color

 Can you count rows by color? Yes, It’s very easy and simple. Here I have a data table that has different colors in rows. I have counted rows by color in these simple steps. 1. I will add a Filter …

Lesson#57: Simple trick to count rows by color Read more »

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2025 Excelabcd | Powered by Responsive Theme
Loading…

Notifications