Page 1 of 1

first line result

Posted: Sat Jan 02, 2021 12:03 pm
by sna
Hi Dear,
in every order delivery charges are there. Now I want the amount of Delivery Charges in the First Line item of every order name. how to do this?
The result as in column c

Thanks

Re: first line result

Posted: Sat Jan 02, 2021 4:58 pm
by puriwutpokin
c2=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$13,A2,B$2:B$13),"")

Re: first line result

Posted: Sun Jan 03, 2021 6:25 am
by sna
Without SUMIF ,is it possible with lookup?

Re: first line result

Posted: Sun Jan 03, 2021 11:16 am
by puriwutpokin
c2=IF(COUNTIF(A$2:A2,A2)=1,LOOKUP(2,1/(A$2:A$13=A2),B$2:B$13),"")

Re: first line result

Posted: Sun Jan 10, 2021 7:52 am
by sna
Thank you so much