Multi Row Formula

[Rhaldhar]

Hi All,

I am expecting the below result according to the input A to B columns. Result required as coming in columns G on basis of formula F.

I need the result same after using multi row formula tool. however, it is not coming.

Please let help me to get the result.

Name should be same in Column A and in B should me 1 and 4 then C value will sum other wise D.

Thanks in advance.

Rajeev

[rzdodson]

@Rhaldhar is this what you are looking for?

[Rhaldhar]

Hi @rzdodson  thanks for looking the issue.

the result should be like below. yellow highlighted sum value (count 1 + 2) of Geeta and Mohan should be in column G, for Geeta - (876+981)=1857 and for Mohan- (200+562) = 762, as shown in below screen.  

[apathetichell]

I'd use a summarize tool and a join - not a multi-row.