SUM COLLECT FORMULA with OR

alexis.ray89371

Hi,

I have this formula working, but need to add an OR statement. I need the formula to work if the last criteria is either "21CNTRL" or "CNTRL". Any help is much appreciated. thanks!

=SUM(COLLECT({Archive-PO Requisitions Range 1}, {Archive-PO Requisitions Range 2}, @cell = [Site Name]@row, {Archive-PO Requisitions Range 3}, [Need by Month Year]@row, {Archive-PO Requisitions Range 4}, "21CNTRL"))

Leibel S

@alexis.ray89371

=SUM(COLLECT({Archive-PO Requisitions Range 1}, {Archive-PO Requisitions Range 2}, @cell = [Site Name]@row, {Archive-PO Requisitions Range 3}, [Need by Month Year]@row, {Archive-PO Requisitions Range 4},OR(@cell= "21CNTRL", @cell="CNTRL")))

Leibel S

@alexis.ray89371

=SUM(COLLECT({Archive-PO Requisitions Range 1}, {Archive-PO Requisitions Range 2}, @cell = [Site Name]@row, {Archive-PO Requisitions Range 3}, [Need by Month Year]@row, {Archive-PO Requisitions Range 4},OR(@cell= "21CNTRL", @cell="CNTRL")))

alexis.ray89371

Thank you!!! It worked.