May 3 2007

Sumif and Countif Formulas in Excel

There are many times when analyzing large amounts of data when you might want to sum or count a column or range based on certain criteria. One example is if you have a database of products you have sold, you might want to know the sum of profits for a particular product - which is [...]

Easily design MySQL databases as familiar spreadsheets in Micros
Get Expert Excel Help Today! 714.262.6893
XLAutomation
XLAutomation

Categories

Excel Poll of the Week

How often do you use Excel macros (VBA)?

View Results

Loading ... Loading ...

Category Cloud

Add Comments Column Headers Concatenate Contest Count CountA CountBlank CountIf Date Drop Down Menu Excel Forum Excel Info Excel Macros Excel Version Formatting HLookup Hyperlink ISBLANK ISERROR ISNA Keyboard Shortcuts Large Left Length Loan Payment Calc Loops Match Mid Protection Rank Record a Macro Right Select Whole Sheet Site Updates Small Status Bar Messages Substitute SumIf Today Trim VLookup

Most Viewed