CODEWITHSUNDEEP
excelexcel-formula
Talha Munir
Talha Munir

Reputation: 526

Calculating Sum in Excel for select values

I have two columns in my sheet. The first column contains the numeric values (money) and the second column, adjacent to it, defines its status (paid or due). Is there a formula I can set for a cell that calculates the sum of the values in the first column which has the status paid in the next row?

Upvotes: 0

Views: 118

Answers (3)

Solar Mike
Solar Mike

Reputation: 8375

So an example of sumif() and countif():

enter image description here

Note that there is a difference in the references.

Upvotes: 1

Murtaza Hussain
Murtaza Hussain

Reputation: 4285

You can use the formula like below to sum it. assuming your money column is B1:B4 and A1:A4 is your paid or due status, 

=SUMIFS(B1:B4,A1:A4,"paid")

Sample results for the sum paid money

Thanks.

Upvotes: 1

Harun24hr
Harun24hr

Reputation: 36840

Use Sumif() function like below.

=SUMIF(B1:B4,"Paid",A1:A4)

enter image description here

Upvotes: 1

Related Questions