Skip to Content
1
Dec 29, 2022 at 03:52 PM

how to manipulate values in the table

359 Views

I am looking for a way on how to manipulate values in the table, for example I am getting the following report

input.jpg

and I would like to sum variable 'count' for XX and YY, when Type is equal to B and "null" (empty cell )

so the resultant table should be like one below (35+16 for XX = 51, and 14+21 for YY =35)

output.jpg

Thanks a lot for any suggestions on how to achieve that

Regards,

Dam

Attachments

input.jpg (12.8 kB)
output.jpg (10.4 kB)