CODEWITHSUNDEEP
excelexcel-formulaworksheet
James Mclaren
James Mclaren

Reputation: 674

Excel, Calculate Sum of one column where the corresponding row in another column equals a value

So I have the following formula which works perfectly to calculate the SUM of an entire column of another worksheet which I reference indirectly.

=SUM(INDIRECT(A4&"!C:C"))

What I need now is to calculate the SUM of C (as above) but only when the relevant row in Column D is equal to Yes.

Can this be done?

Thanks,

Upvotes: 0

Views: 1688

Answers (1)

chris neilsen
chris neilsen

Reputation: 53135

Try this

=SUMIF(INDIRECT(A4&"!D:D"),"Yes",INDIRECT(A4&"!C:C"))

Upvotes: 4

Related Questions