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 ...
=SUMPRODUCT(NOT(ISNA(C2:C25))*D2:D25)
Maybe with this formula if the invalid content is an NA error.
=SUMPRODUCT(IF(ISERROR(C2:C25),0,1)*D2:D25)
Or maybe with this formula to exclude any error. Enter this formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.