CODEWITHSUNDEEP
excelexcel-formularangesumifs
Sweety Mathews
Sweety Mathews

Reputation: 1

Sumifs to sum the column using excel formula

How to sum 4th column satisfying the difference between first and second column equal to 2 and also satisfying a criteria in the third column using excel formulas

Upvotes: 0

Views: 37

Answers (1)

Scott Craner
Scott Craner

Reputation: 152525

use SUMPRODUCT:

=SUMPRODUCT((A2:A10-B2:B10=2)*(C2:C10="A")*D2:D10)

enter image description here

Upvotes: 1

Related Questions