How to sum only the positive numbers in Excel?
This video shows how to use SUMIF or SUMIFS.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
How to unhide one specific column in Excel.
Say that C, F, and E are hidden columns in Excel.
You only want to unhide column D but leave C & E hidden.
This video shows you how.
How to use the AutoSum when you need to sum non-contiguous cells in Excel.
Microsoft Excel - How to Unhide ALL rows and columns?
There appear to be a lot of people who want to know how to unhide all columns or all rows in a single command. This short video will show you how.
Many people are asking about the AutoSum shortcut in Excel.
This video covers six topics about conditional sums in Excel.
Table of Contents
(0:00) Topics in this video
(0:33) Conditional Sum in Excel
(1:17) SUMIFS with multiple criteria
(2:09) SUMIFS with 2 criteria in same column
(5:33) How to Drag SUMIFS formula
(6:27) SUMIFS with Function in Criteria
(7:22) SUMIFS with Range of Dates
How to calculate a percentage of total in Excel.
Common search terms answered by this video:
How to add percentages to sum in Excel
how to calculate percentage of a sum in Excel
how to change a percentage on a sum on Excel
how to do a percent sum in Excel
how to do a percentage of a total sum on Excel
how to do a percentage sum in Excel
how to do a percentage sum on Excel
how to do an percentage sum on Excel
how to do percentage sum in Excel
how to find a precentage of sums in Excel
Table of Contents
(0:00) Add a Total in Excel
(0:10) Division formula in Excel
(0:22) F4 to add dollar signs in Excel for absolute reference
(0:32) Formatting as a percentage with 1 decimal place
(0:37) Double-click Fill Handle to copy formula
(0:45) Wrap-up
Carlos asks how to have the smallest number have the largest data bar in Microsoft Excel.
Microsoft Excel Conditional Formatting offers three data visualization tools. Two of them are easily reversible. But Data Bars don't have an easy way to reverse.
Nancy Faust takes us into the "Danger Zone" as I try using a devious number format to mask negative numbers as positive numbers.
Table of Contents
(0:00) Small Number Long Data Bar
(0:14) Reversing Color Bar in Excel
(0:24) Reversing Icon Sets in Excel
(0:42) Data Bar outside cell
(1:08) Negative Values Data Bar setting
(1:24) Show Bar Only in Data Bars
(1:34) Danger Zone: Devious Number Format
(2:14) Showing Negative numbers as positive in Excel
(2:45) Wrap-up
