Subscribe Bookmark RSS Feed

Formula : col sum by multi-category (2)

jameskim

Community Trekker

Joined:

May 17, 2012

^-^)/  Hi~  I need your advice.

I would like to know about JMP formula.

I knew "col sum by category 1 & 2" formula as below.

Col Sum(:data, :category1, :category2)

However, how can I use col sum formula by category2 with exclude function

I do not want to delete raw data, but I want to calculate col sum with exception.

Combination with other formula function would be OK.

I appreciate your advice in advance

catrgory1catrgory2data

Col sum(:data, :category1, :category2)
with exclude "O,T,Y" from category2

AO12+3+4+5=14
AP22+3+4+5=14
AQ32+3+4+5=14
AR42+3+4+5=14
AS52+3+4+5=14
AT62+3+4+5=14
BU77+8+1+3=19
BV87+8+1+3=19
BW97+8+1+3=19
BX17+8+1+3=19
BY27+8+1+3=19
BZ37+8+1+3=19