Forum Discussion
Sum excluding some invalid data
Hi I need quick help. I need to create a spreadsheet that will sum some values but I need to exclude some rolls as a requirement. Can you help me with it? This is an example (but in my case, is ...
Hi Use sumif function, column C (content) and D (value) =SUMIF(C2:C6,"Valid Content",D2:D6)
Cosmetic comment. Since % is required, perhaps
=SUMIF(C2:C6,"Valid Content",D2:D6) / SUM(D2:D6)