# SUMIF-Function

## How to use COUNTIFS and SUMIF together in Excel

If you want to become an Excel experts then you must have complete command on Excel functions and different options. Sometime you need to use countifs and sumif function together in Excel sheet to count and sum the resulted values. Read More

## How to Sum or Count cells based on background color in Excel

Suppose during working on Excel, if you get a worksheet in which there are different kind of background colors in range of cells. Now if someone ask you how to sum or count cells based on background color in Excel. It is not an easy task to get the proper answer in quick way. In this guide we have to discuss how to sum or count cells based on background colors in Excel. Read More

## What is Difference between SUMIF and SUMIFS Function

SUMIF function allows you to conditionally sum the values which match the given single criteria, While SUMIF is used to conditionally sum the values which match the multiple criteria. Most of the person little bit confused during using these functions. Today we have to discuss what is the difference between the SUMIF and SUMIFS function in Excel. Read More