A AV114 Member Jan 31, 2019 #1 I have number values and what I'm looking for is a formula that will add all the values together but will only add total values once one time. Example Code: O Code Imports Total 1703024 10 44 1703024 4 1703024 20 1703021 20 110 1703024 10 1703021 90
I have number values and what I'm looking for is a formula that will add all the values together but will only add total values once one time. Example Code: O Code Imports Total 1703024 10 44 1703024 4 1703024 20 1703021 20 110 1703024 10 1703021 90
P premjeetgupta Member Jan 31, 2019 #2 Can you check this following formula. =IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$7,A2,$B$2:B$7),"") Attached sample working file also. Thanks, Attachments Book2.xlsx 10.1 KB · Views: 2
Can you check this following formula. =IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$7,A2,$B$2:B$7),"") Attached sample working file also. Thanks,
