LinkBack URL
About LinkBacks
if you want array you can do it like this...
or
=SUM(IF((A1:A8=C1)+(A1:A8=C2)+(A1:A8=C3),B1:B8,0))
manually entering "letter" for condition...
see sample file attached.=SUM(IF(A1:A8={"B","E","H"},B1:B8,0))
adding numbers.xlsx
if you want array you can do it like this...
or=SUM(IF((A1:A8=C1)+(A1:A8=C2)+(A1:A8=C3),B1:B8,0))
manually entering "letter" for condition...
see sample file attached.=SUM(IF(A1:A8={"B","E","H"},B1:B8,0))
adding numbers.xlsx
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks