• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

Excel 2013 SUMPRODUCT

Hi,
Just upgraded to excel 2013 and a previously work function no longer works, does the below require updating?

=SUMPRODUCT(--(csv!$S$2:$S$100000=C10),--(csv!$T$2:$T$100000=D10),--(csv!$E$2:$E$100000=E10))
0
hellblazeruk
Asked:
hellblazeruk
1 Solution
 
NBVCCommented:
Should still work, although you can make it much more efficient now with 2013 using COUNTIFS

=COUNTIFS(csv!$S$2:$S$100000,C10,csv!$T$2:$T$100000,D10,csv!$E$2:$E$100000,E10)
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now