Excel Tips
Sum Records That Match a Criterion »
March 29, 2022
That COUNTIF function is cool. Is there a way to sum all records that match a criterion?
Build a Table That Will Count by Criteria »
March 28, 2022
I need to build a summary table using COUNTIF functions. How can I enter one formula that can be copied?
Count Records That Match a Criterion »
March 25, 2022
I have a large data set. I want to count the number of records that meet a certain criterion.
Stop Showing Zeroes in Cell Links »
March 24, 2022
I have the data set shown below. I need live formulas that replicate this data set on another worksheet. When I set up the formulas, I get zeroes where the blank cells are located. I can use =IF(ISBLANK(A1),””,A1) to suppress the zeroes, but then if I try to do any math on A1 in the worksheet copy, I am getting #VALUE errors.
March 23, 2022
I have a series of closing stock prices. If the price for the day goes up, I want to display an up symbol. If the price goes down, display a down symbol.
Tiered Commission Plan with IF »
March 22, 2022
I am calculating a commission based on a sliding scale. The rate is based on the size of the sale, using the table shown here.
March 21, 2022
The CFO decided we should only pay the 2% bonus if a second condition is met. The GP% must be 50% or higher in addition to the sale being over $20,000.
March 18, 2022
My VP of Sales announced that we are paying a 2% bonus for all sales over $20,000 this month. How do I calculate the bonus?
Format Every Other Row in Green »
March 17, 2022
Got any cool uses for MOD? Got any old-school methods for applying the greenbar format that was in the Excel 2003 AutoFormat dropdown?