Solved

# Excel 2013 SUMPRODUCT

Posted on 2014-12-10
Medium Priority
116 Views
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
Question by:hellblazeruk
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
1 Comment

LVL 23

Accepted Solution

NBVC earned 2000 total points
ID: 40492439
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,â€¦
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
###### Suggested Courses
Course of the Month10 days, 12 hours left to enroll