Sumproduct gives me error
Closed
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Jun 18, 2014 at 07:13 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Jun 22, 2014 at 07:04 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Jun 22, 2014 at 07:04 PM
Related:
- Sumproduct gives me error
- Network error occurred - Guide
- Cmos checksum error - Guide
- Debian gpg error - Guide
- Bios rom checksum error - Guide
- Nvlddmkm.sys error - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 18, 2014 at 09:13 PM
Jun 18, 2014 at 09:13 PM
jutulu, Good evening.
Try to use:
=SUMPRODUCT((C4:C453="Juan")+(C4:C453="Alanzon")+(C4:C453="paul"))
Is this what you desire?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=SUMPRODUCT((C4:C453="Juan")+(C4:C453="Alanzon")+(C4:C453="paul"))
Is this what you desire?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Jun 19, 2014 at 07:22 PM
Jun 19, 2014 at 07:22 PM
Hi mazzaropi. Thanks, however, how can use array formula to make I shorter. Gracias
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Jun 22, 2014 at 07:04 PM
Jun 22, 2014 at 07:04 PM
Hi. Any ideas on the above as to how to use array formula to shorten the sumproduct formula? Thanks
Also, can sumproduct work with the * symbol too, or only with the + symbol?
Thanks
Also, can sumproduct work with the * symbol too, or only with the + symbol?
Thanks
