Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: This time I use the SUMPRODUCT function for a quicker solution. SUMPRODUCT can be used to count with conditions (within the same group).
Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: I use functions VLOOKUP, AND to identify rows if a condition is met within the same group. Continue reading
Learn how to add numbers in Microsoft Excel using these functions: SUM, SUMIF, SUMIFS. Continue reading
Use Excel’s data validation feature to restrict values that can be entered into cells.
Data validation can save you hours of data cleanup work! Continue reading
A hyperlink is an easy way to jump from one location to another location. The destination could be to the same workbook, an external workbook or a website.
There are two ways to create a hyperlink in Microsoft Excel: Continue reading
Watch this video to learn how to combine the offset function with a combo box. This will make it easy to retrieve the desired value from your data.
Learn how to retrieve a value or several values using Microsoft Excel’s offset function. Offset is one of my favorite functions due to it’s flexibility. Continue reading
What’s the difference between Compound Interest and Simple Interest?
I know that there’s a difference but I often forget the details so I created this video for you and for me! Continue reading
Calculate the future value of your money in Microsoft Excel using the Future Value function. Continue reading
Learn how to group a column of dates by Year & Month and sum another field.
Excel’s pivot table ‘Group’ feature only takes a few clicks of the mouse and can save so much time! Continue reading