I have three columns in which I want sum value of col3 based on col1 and col2 value
if col1 = 1 and col2 = 40
then sum all value of col3
but if col1 = 1 and col2 = 20 or
col1 = 2 and col2 = 40
then sum col3 value according to the col1 and col2 value
for this purpose I am sharing the link of google sheet with dummy data set please check and give me your suggestion or help.
Thank you.Shared google sheet
if col1 = 1 and col2 = 40
then sum all value of col3
but if col1 = 1 and col2 = 20 or
col1 = 2 and col2 = 40
then sum col3 value according to the col1 and col2 value
for this purpose I am sharing the link of google sheet with dummy data set please check and give me your suggestion or help.
Thank you.Shared google sheet
Last edited by a moderator: