Sanjay Gandhi
asked on
Microsoft Excel
Hi,
I want a SUMPRODUCT which is conditional. Please have a look at the file, and provide an answer.
Thanks.
SumProduct.xlsx
I want a SUMPRODUCT which is conditional. Please have a look at the file, and provide an answer.
Thanks.
SumProduct.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
And in which situations can we use this notation?
Thanks.
=SUMPRODUCT((B4:B6="East")