Hi  I need a formula that sums the first 3 cells of component1 that contains ``yes'' (result should be 88)
Also  I need to sum the first 3 cells of component1 & component2 that contains ``yes'' (result should be 121)
Thanks in advance.
Also  I need to sum the first 3 cells of component1 & component2 that contains ``yes'' (result should be 121)
Thanks in advance.
Attachments

4.8 KB Views: 14