How to apply sumifs() formula or function

I have sales data, and I’ll show you how to apply the SUMIFS formula on it.

I have the data below, please take a look.

Type sumifs Formula.

And select sum_range

And then after that, select Criteria Range 1.

Then select Criteria 1.

Then select Criteria range 2.

Then select creteria 2.

Click OK.

 and your SUMIFS formula is done.

Thankyou.

Leave a Reply

Your email address will not be published. Required fields are marked *