Using an OR operator in Array functions I have a dataset that seems to lend itse

Question

Using an OR operator in Array functions

I have a dataset that seems to lend itself to evaluating with an array formula..

In column C, I have left, right, center, mod, top, and bottom as values. I wish to count the sum of values for smith of the values left, right and mod,

The summation occurs from the numerical data in column E.

I am trying to use the below array formula, and cant get it to work. It wasentered by using Ctrl+Shift+Enter simultaneously.

Can anyone determine my problem. Perhaps I do not understand something.

{=SUM((C5:C1335="left")*(C5:C1335="right")*(C5:C1335="mod")*((D5:D1335="smith")*(E5:E1335))}

Help me!

Explanation / Answer

Try...

=SUM(IF(ISNUMBER(MATCH(C5:C1335,{"left","right","mod"},0)),IF(D5:D1335="smith",E5:E1335)))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!!

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.