Excel Guides

Determining Combinations to Make a Total in Excel

There are a few different ways that you can go about determining combinations to make a total in Excel. One way is to use the SUMIF function. This function allows you to specify a range of cells, and then sum only the cells that meet a certain criteria. For example, if you wanted to sum only the cells in column A that were greater than 10, you would use the following formula:

=SUMIF(A:A,">10")

You can also use the SUMIF function to sum cells based on multiple criteria. For example, if you wanted to sum only the cells in column A that were greater than 10 and less than 20, you would use the following formula:

=SUMIF(A:A,">10",A:A,"<20")

Another way to determine combinations to make a total in Excel is to use the COUNTIF function. This function allows you to count the number of cells in a range that meet a certain criteria. For example, if you wanted to count the number of cells in column A that were greater than 10, you would use the following formula:

=COUNTIF(A:A,">10")

You can also use the COUNTIF function to count cells based on multiple criteria. For example, if you wanted to count the number of cells in column A that were greater than 10 and less than 20, you would use the following formula:

=COUNTIF(A:A,">10",A:A,"<20")

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.