CODEWITHSUNDEEP
excelexcel-formula
user4259224
user4259224

Reputation: 27

Total columns with specific value only

I have 3 columns. A, B and C. I would to add up or Autosum column C but only include (column C) amounts which have column A have as '0' as an amount. Please assist

Upvotes: 0

Views: 35

Answers (1)

Shauno_88
Shauno_88

Reputation: 665

You would want to use the SUMIF function, this page explains more about the function in detail.

http://www.techonthenet.com/excel/formulas/sumif.php

So your formula will look something like this but with the ranges you require

=SUMIF($A$2:$A$6, 0, $C$2:$C$6)

Upvotes: 1

Related Questions