Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Microsoft Excel

Posted on 2012-09-12
Medium Priority
274 Views
Hi,

I want a SUMPRODUCT which is conditional. Please have a look at the file, and provide an answer.

Thanks.
SumProduct.xlsx
0
Question by:sanjay-gandhi
• 2

LVL 18

Accepted Solution

krishnakrkc earned 2000 total points
ID: 38389989
Hi

=SUMPRODUCT(--(B4:B6="East"),C4:C6,D4:D6)

Kris
0

LVL 50

Expert Comment

ID: 38390002
Or

=SUMPRODUCT((B4:B6="East")*C4:C6*D4:D6)
0

Author Closing Comment

ID: 38390005
Can you explain what does --(B4:B6="East") mean? I am getting my answer fine.

And in which situations can we use this notation?

Thanks.
0

LVL 18

Expert Comment

ID: 38390074
0

## Featured Post

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month12 days, 4 hours left to enroll