Mar 29 2021 01:26 AM
Mar 29 2021 04:55 AM
I would be happy to know if I could help with this information.
Nikolino
I know I don't know anything (Socrates)
Mar 29 2021 05:33 AM
Mar 29 2021 10:13 AM
Here is an old little example with names and amounts.
I wish you much success in your project.
Nikolino
I know I don't know anything (Socrates)
Mar 30 2021 01:43 AM
As variant for such model
formulas are
in G2:
=IFNA(SUMPRODUCT(
($B$2:INDEX($B$2:$B$13,
MATCH(1,INDEX(($B$2:$B$13=F2)*($D$2:$D$13="no"),0),0) ) =
F2)*
($D$2:INDEX($D$2:$D$13,
MATCH(1,INDEX(($B$2:$B$13=F2)*($D$2:$D$13="no"),0),0) ) =
"yes")), SUMPRODUCT(($B$2:$B$13=F2)*($D$2:$D$13="yes")))
In J2:
=IFNA(SUMPRODUCT(
($C$2:INDEX($C$2:$C$13,
MATCH(1,INDEX(($C$2:$C$13=I2)*($D$2:$D$13="no"),0),0) ) =
I2)*
($D$2:INDEX($D$2:$D$13,
MATCH(1,INDEX(($C$2:$C$13=I2)*($D$2:$D$13="no"),0),0) ) =
"yes")), SUMPRODUCT(($C$2:$C$13=I2)*($D$2:$D$13="yes")))
In M2:
=IFNA(SUMPRODUCT(
(
($B$2:INDEX($B$2:$B$13,
MATCH(1,INDEX( ( ($B$2:$B$13=L2)+($C$2:$C$13=L2) )*($D$2:$D$13="no"),0),0) ) =
L2) +
($C$2:INDEX($C$2:$C$13,
MATCH(1,INDEX( ( ($B$2:$B$13=L2)+($C$2:$C$13=L2) )*($D$2:$D$13="no"),0),0) ) =
L2)
)
*
($D$2:INDEX($D$2:$D$13,
MATCH(1,INDEX(( ($B$2:$B$13=L2)+($C$2:$C$13=L2) )*($D$2:$D$13="no"),0),0) ) =
"yes")), SUMPRODUCT(( ($B$2:$B$13=L2)+($C$2:$C$13=L2) )*($D$2:$D$13="yes")))
Hope it shall work on 2007.