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.

Display Up/Down Arrows »

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.

IF with Two Conditions »

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.

Use IF to Calculate a Bonus »

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?