SUMPRODUCT in vba

Hi,

I have the following sumproduct formula

=SUMPRODUCT(($A$2:$A$16 = 3) *( $B$2:$B$16 = "ddd" )*( $C$2:$C$16 = 3 )*( $E$1:$K$1 = "Mar" ) * ( $E$2:$K$16 ))

How can i pull the criteria (3, ddd, 3, Mar) from textboxes and use a evaluate function to calculate it?

That works. Thank you!

Is it possible to get the cell addresses instead of the value?

Originally Posted by thoufik11

Is it possible to get the cell addresses instead of the value?

What do you mean by cell addresses... the cell addresses of what?

cell address of the result.

for example;

Attachment 745150

if I choose 3 ddd 3 Mar, how can i get the result as G2?

Your attachment is invalid. You must follow the steps outlined in the yellow box at the top of this window to attach a file for us to see it.

cell address of the result.

for example;



if I choose 3 ddd 3 Mar, how can i get the result as G2?

I'm about to go to sleep for the night but I have to say I am completely confused now. Your original question dealt with four TextBoxes and ran a sum down a mathematical calculation for multiple rows for four different columns and a fixed cell... now your have four cells instead of TextBoxes and only one row of data where you are wanting to find the value. I do not see how to apply the formula you were evaluating originally (multiple row summation) to your single row. You are going to have to provide a lot more detail as to what you are looking for if you expect to get a solution that you can use.

Hi, That works.

Thank you so much!