CODEWITHSUNDEEP
excelexcel-formula
Jeffrey Legaspi
Jeffrey Legaspi

Reputation: 3

Excel - How to add cells that has value on the same column but different rows?

I want to know the actual standard on the following excel:

Sample Table

I need to sum the row 8 depending on the inputs on row 3 say for example, actual data on row 3 is until Wednesday (column D), the formula will add columns B, C, and D on row 8.

Thanks in advance.

Upvotes: 0

Views: 117

Answers (1)

xwhitelight
xwhitelight

Reputation: 1579

Use SUMIFS with the criteria <> (not equal to null): =SUMIFS(B8:F8,B3:F3,"<>")

Upvotes: 1

Related Questions