Date: 2009-08-14 06:35 pm (UTC)
schnurble: (Default)
From: [personal profile] schnurble
I knew there was a way to do COUNTIF/SUMIF with more than one condition, the function is SUMPRODUCT

So this counts the occurences of Ron getting money from Slytherin:
=SUMPRODUCT((A1:A10="Ron")*(C1:C10="Slytherin"))

And this would give the amount of money he got from there:
=SUMPRODUCT((A1:A10="Ron")*(C1:C10="Slytherin")*(B1:B10))

*geek*
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

If you are unable to use this captcha for any reason, please contact us by email at support@dreamwidth.org

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

Profile

slowfox: Slowfox' default icon (Default)
slowfox

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 11th, 2025 05:28 am
Powered by Dreamwidth Studios