"Kstalker" wrote:
Mail enroute.
Unsure if it is possible.

Thanks for alert. I can only access my yahoo acc in about 10 hours time, so
hang in there awhile. I will post back the findings either way <g.

In the interim ... FWIW I had actually prepared a response (below) to your
earlier post yesterday on the new issue raised before your 2nd post came
through. In case you would like to see it through:

The formula below is being used to sumproduct any data where the
criteria "stop" is met. However I can only sum this data (sumif) which
is not accurate as if more than one coumn contains the criteria it is
summed . Is there a way that I can set the criteria as in using the
sumif function but still produce the sumproduct results??

=IF(S30=0,0,SUMPRODUCT(SUMIF($A$2:$Q$2,"stop",A19: Q19),SUMIF($A$2:$Q$2,"stop
",A30:Q30)/S30))

Think I might have lost my way somewhere here ..

As it stands, your posted formula is equivalent to:

=IF(S30=0,0,SUMIF($A$2:$Q$2,"stop",A19:Q19)*SUMIF( $A$2:$Q$2,"stop",A30:Q30)/
S30)

(i.e. with the "*" replacing the SUMPRODUCT( ..))

So, supposing you have:

In A2:C2: stop stop stop
In A19:C19: 10 10 10
In A30:C30: 100 100 100
In S30: 2

(All other cells within the posted formula are assumed blank)

Your posted formula will return: 4500 (nothing wrong here), viz.:

SUMIF($A$2:$Q$2,"stop",A19:Q19) returns: 30
SUMIF($A$2:$Q$2,"stop",A30:Q30)/S30 returns: 150
and then SUMPRODUCT(30,150) will return: 30 x 150 = 4500

What is your expected result ?
If it's another value, pl explain how the expected result is computed

And if we clear say, cell C2, so that it becomes

In A2:C2: stop stop <blank
In A19:C19: 10 10 10
In A30:C30: 100 100 100
In S30: 2

Your posted formula will return: 2000 (again, nothing wrong here)
What is your expected result ?
If it's another value, pl explain how the expected result is computed

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
---