I have a spread sheet I use to manage a soccer league.
This shows me of the registered players who is on Dk Blue team.
=SUMPRODUCT($AU$2:$AU$131=Dk Blue, $O$2:$O$131=x)
This shows me the team strength based on assigned values of the players.
=SUMPRODUCT($AU$2:$AU$131=Dk Blue, $AW$2:$AW$131)
I
Just an off-the-top-of-my-head stab at it, but can't you do something
like:
=SUMIF(($O$2:$O$131=x AND $AU$2:$AU$131=Dk Blue), $AW$2:$AW$131)
?
Paul
On Tue, 29 Jul 2014 16:34:00 -0500
Wade Smart wadesm...@gmail.com wrote:
I have a spread sheet I use to manage a soccer league.
This shows
Gives a Err:508.
I dont think it can be text that its comparing.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Tue, Jul 29, 2014 at 4:42 PM, Paul paulste...@afrihost.co.za wrote:
Just an off-the-top-of-my-head stab at it, but can't you do something
Yeah, you're right, forgot how SUMIF works for a moment...
It's easy with an intermediate column, but one-shot...
In fact, I'm not sure that it isn't *supposed* to be done with
intermediate columns. At least, the only way I can see that it could be
done without them would be either some sort of
I guess I should have just tried this:
=SUMPRODUCT($O$2:$O$131=x,$AU$2:$AU$131=Dk Blue, $AX$2:$AX$131)
I thought I had and it did not work but, it does.
:D Thanks
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Tue, Jul 29, 2014 at 5:16 PM, Paul