Hello there,

i would like to have excel compute a sum of a previous multiplication of values which are in different columns but in the same row if in the very same row there is for example A1="string1" and B1="string2". that shud be performed over for example row 1 till row 2000...

can this be done via a simple excel formula? i already tried sumifs and sumproduct but that didnt work out so far.

thanks very much for your help!