How to Use Math Functions in C# for Excel with IronXL

Which Math Functions Are Available?

Beyond core aggregation functions, IronXL supports a comprehensive suite of mathematical operations that seamlessly integrate with C# Excel workflows. Each function is optimized for performance and accuracy:

The Sum() method calculates the total sum of selected cells, perfect for financial totals, inventory counts, or cumulative calculations. It efficiently processes thousands of cells while maintaining decimal precision.

The Avg() method determines the average value of selected cells, ideal for calculating mean scores, average sales figures, or statistical analysis. This function automatically excludes empty cells and non-numeric values.

The Min() method identifies the minimum number within selected cells, useful for finding lowest prices, minimum thresholds, or baseline values in data analysis.

The Max() method finds the maximum number within selected cells, essential for identifying peak values, highest scores, or upper limits in datasets.

These mathematical functions work seamlessly with IronXL's other features like cell formatting and formula support, enabling comprehensive Excel automation scenarios.

What Data Types Can I Aggregate?

These functions are valuable tools for analyzing data and deriving insights from Excel spreadsheets. IronXL's math functions support various numeric data types commonly found in Excel files:

• Integers and Decimals: Standard numeric values processed with full precision
• Currency Values: Monetary amounts with currency symbols correctly parsed
• Percentages: Percentage values handled appropriately in calculations
• Scientific Notation: Large or small numbers in scientific format supported
• Date Serial Numbers: Excel's internal date representation aggregated when needed

When working with mixed data types, IronXL intelligently handles conversions and ensures accurate results. For complex scenarios involving multiple worksheets or workbooks, you can easily load and process multiple Excel files simultaneously.

Here's an example demonstrating aggregation across different numeric formats:

using IronXL;

// Load workbook containing various numeric formats
WorkBook workBook = WorkBook.Load("financial-data.xlsx");
WorkSheet salesSheet = workBook.GetWorkSheet("Q4Sales");

// Calculate total revenue from currency-formatted cells
decimal totalRevenue = salesSheet["B2:B50"].Sum();
Console.WriteLine($"Total Q4 Revenue: ${totalRevenue:N2}");

// Find the highest individual sale amount
decimal maxSale = salesSheet["B2:B50"].Max();
Console.WriteLine($"Largest Sale: ${maxSale:N2}");

// Calculate average sale amount
decimal avgSale = salesSheet["B2:B50"].Avg();
Console.WriteLine($"Average Sale: ${avgSale:N2}");

// Process percentage data (e.g., tax rates)
decimal avgTaxRate = salesSheet["D2:D50"].Avg();
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}");

using IronXL;

// Load workbook containing various numeric formats
WorkBook workBook = WorkBook.Load("financial-data.xlsx");
WorkSheet salesSheet = workBook.GetWorkSheet("Q4Sales");

// Calculate total revenue from currency-formatted cells
decimal totalRevenue = salesSheet["B2:B50"].Sum();
Console.WriteLine($"Total Q4 Revenue: ${totalRevenue:N2}");

// Find the highest individual sale amount
decimal maxSale = salesSheet["B2:B50"].Max();
Console.WriteLine($"Largest Sale: ${maxSale:N2}");

// Calculate average sale amount
decimal avgSale = salesSheet["B2:B50"].Avg();
Console.WriteLine($"Average Sale: ${avgSale:N2}");

// Process percentage data (e.g., tax rates)
decimal avgTaxRate = salesSheet["D2:D50"].Avg();
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}");

IRON VB CONVERTER ERROR developers@ironsoftware.com

Can I Apply Functions to Rows and Columns?

For more flexibility, these functions can also be applied to single or multiple rows and columns. Learn more about selecting ranges including entire rows and columns. This capability is particularly useful when working with structured data requiring dimension-specific calculations.

You can apply math functions to:

• Entire Columns: Calculate totals for complete data columns
• Entire Rows: Aggregate values across row-based records
• Multiple Ranges: Combine multiple selections for complex calculations
• Named Ranges: Use named ranges for maintainable code

Here's a practical example showing row and column aggregation:

using IronXL;

WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet dataSheet = workBook.DefaultWorkSheet;

// Calculate sum for entire column (e.g., all sales data)
decimal columnTotal = dataSheet.GetColumn(1).Sum(); // Column B

// Calculate average for entire row (e.g., monthly averages)
decimal rowAverage = dataSheet.GetRow(4).Avg(); // Row 5

// Work with multiple columns simultaneously
for (int col = 1; col <= 12; col++) // Columns B through M
{
    decimal monthlyTotal = dataSheet.GetColumn(col).Sum();
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}");
}

// Calculate grand total across multiple ranges
var q1Range = dataSheet["B2:D50"];
var q2Range = dataSheet["E2:G50"];
decimal firstHalfTotal = q1Range.Sum() + q2Range.Sum();

using IronXL;

WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet dataSheet = workBook.DefaultWorkSheet;

// Calculate sum for entire column (e.g., all sales data)
decimal columnTotal = dataSheet.GetColumn(1).Sum(); // Column B

// Calculate average for entire row (e.g., monthly averages)
decimal rowAverage = dataSheet.GetRow(4).Avg(); // Row 5

// Work with multiple columns simultaneously
for (int col = 1; col <= 12; col++) // Columns B through M
{
    decimal monthlyTotal = dataSheet.GetColumn(col).Sum();
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}");
}

// Calculate grand total across multiple ranges
var q1Range = dataSheet["B2:D50"];
var q2Range = dataSheet["E2:G50"];
decimal firstHalfTotal = q1Range.Sum() + q2Range.Sum();

IRON VB CONVERTER ERROR developers@ironsoftware.com

For advanced Excel manipulation scenarios, combine these math functions with other IronXL features like creating charts, applying conditional formatting, or exporting to different formats. This makes IronXL a comprehensive solution for Excel automation in .NET applications, whether building reporting tools, data analysis systems, or business intelligence dashboards.