jcox
Structural
- Jul 16, 2002
- 37
I am having trouble with the following formula. I am trying to add a series of numbers based on the following criteria:
Row 7 must be a blank number
Row 6 must contain certain "triggers"
if these two conditions are met then sum the related cells in Row 9.
=SUMPRODUCT(ISBLANK(J7:Z7)*(J9:Z9)*OR(J6:Z6={"Text1";"Text2";"Text3";"Text4"}))
I have used something similar before, but only in vertical arrays. The first test seems to be fine, the error is happening somehow in the 2nd test. I can make the test array work fine by itself, but I can't seem to make it work as part of the formula. In the sumproduct formula the second condition seems to be always "True" regardless of what is in Row 6. I would love to redo the spreadsheet, but since I'm trying to help someone out, I doubt that is a possibility. Basically, someone has invented an elaborate spreadsheet and now needs a method of managing it.
Thanks
Row 7 must be a blank number
Row 6 must contain certain "triggers"
if these two conditions are met then sum the related cells in Row 9.
=SUMPRODUCT(ISBLANK(J7:Z7)*(J9:Z9)*OR(J6:Z6={"Text1";"Text2";"Text3";"Text4"}))
I have used something similar before, but only in vertical arrays. The first test seems to be fine, the error is happening somehow in the 2nd test. I can make the test array work fine by itself, but I can't seem to make it work as part of the formula. In the sumproduct formula the second condition seems to be always "True" regardless of what is in Row 6. I would love to redo the spreadsheet, but since I'm trying to help someone out, I doubt that is a possibility. Basically, someone has invented an elaborate spreadsheet and now needs a method of managing it.
Thanks
