At 08:53 09/10/2016 -0400, Bruce Hohl wrote:
And, for 2 criteria like this: =SUMPRODUCT((YEAR(A1:A50)=2011)*(B1:B50="ZZZ"))
Except that this - though it will work - is missing the point of
SUMPRODUCT(). That multiplication sign is unnecessary. It's a bit
like using =SUM(A1+A2) (which will also work) instead of =SUM(A1;A2)
or just =A1+A2.
Try =SUMPRODUCT(YEAR(A1:A50)=2011;B1:B50="ZZZ") .
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
