Extending previous 'conditional statements solution'

[gigaworks]

As always I'm very greatful for all your help!



Hello,

A few days ago I posted a problem which received a very quick and helpful response from Paul (thanks Paul!) which involved the use of SUMPRODUCT and what I believe is called a double unary operator (--). Here's the original post with Paul's solution:

http://www.excelforum.com/excel-gene...-new-post.html

I've since discovered that a previously unknown column of data (I'm transcribing data from paper documents) needs to be included in the calculations. Specifically, the new column of data (shown in yellow in the attached example) has to be taken into consideration when counting product quantities. An explanatory pseudo code statement, also appearing in yellow in the example sheet, describes what I'm hopelessly trying to achieve.

Thank you yet again for taking the time to help out.

[zbor]

Do you mean this?

=SUMPRODUCT(--($A$2:$A$13=$F9),--($C$2:$C$13=RIGHT(G$7;1)+0),$D$2:$D$13/5)

[Richard Buttrey]

Hi,

In G9 copied across and down

=SUMPRODUCT(--($A$2:$A$13=$F9),--($C$2:$C$13=RIGHT(G$7,1)+0)*($D$2:$D$13/5))

Rgds