IF Mutiple Same Values in Same Column Formula

[rowbro]

Hi folks - I am trying to figure out the most simple formula to do the following:

IF the value of two items in the same column have the same value (stock name) AS WELL AS the same date AND the same additional value (buy or sell), then, calculate a weighted average price using the following sum: sumproduct(A1*B1+A2*B2)/sum(B1+B2).

Thanks.

 

[Chris Mack]

I would use an "IF(SUM(IF" array formula (or an "IF(SUMPRODUCT" formula) to calculate whether or not multiple matches exist, and then perform a weighted average calculation if that condition was present.

Chris.

 

[rowbro]

Thanks Chris - the issue I have, however, is that I want the "IF" to look for repeated values, not to have to say "IF(A1="Blah",,)". The reason for this is that there are about 50 possible values that could be repeated. Any work around for this?

Thanks again.

 

[Chris Mack]

I'd really have to have a better idea of the way the sheet is structured and what you're looking for specifically.

What I'm suggesting is more of a "IF(SUM(IF($A$1:$A$100="Blah",,)".

Chris.