Hi
I have the columns A1:A1000 and B1:B1000 in Excel 2010. The cells of both columns containing every data type. That means numbers or strings or are empty or (unfortunately) they have error types (numbers divide by zero, #DIV/0!, #VALUE!, e.g. ).
Is it possible somehow, in C1 cell to sum up all the positive numbers in B1:B1000, but only if the corresponding cells (Ai ) contain also positive numbers?
Thanks.
Bookmarks