Arrays/Functions/Different datatypes in a formula?

J

Jess

I am currently using this formula.

=SUMPRODUCT(--($C$6:$C$148=2006),--($E$6:$E$148=5000),--($G$6:$G$148=A),--
($I$6:$I$148))

Although all values in all the columns are numeric, one column stores
alphabetical values, and the formula is not returning any value. is it
because arrays have to contain the same data type?

Thanks in advance
 
L

Leo Heuser

Jess said:
I am currently using this formula.

=SUMPRODUCT(--($C$6:$C$148=2006),--($E$6:$E$148=5000),--($G$6:$G$148=A),--
($I$6:$I$148))

Although all values in all the columns are numeric, one column stores
alphabetical values, and the formula is not returning any value. is it
because arrays have to contain the same data type?

Thanks in advance
Click to expand...

Hi Jess

Maybe all you need is a pair of double quotes around A
to tell Excel, that it's text:

($G$6:$G$148="A")
 
J

Jess

Hi Leo, Thanks so much.I had tried that earlier, but it returned an error,
that was a mistake on my part, coz i was trying it on another column. Its
working now,thank you!

Guess things work out the best when u work a little slower,rather than
trying to get things done fast.Miss what your looking for...........
T's again.
 
L

Leo Heuser

Jess said:
Hi Leo, Thanks so much.I had tried that earlier, but it returned an error,
that was a mistake on my part, coz i was trying it on another column. Its
working now,thank you!

Guess things work out the best when u work a little slower,rather than
trying to get things done fast.Miss what your looking for...........
T's again.
Click to expand...

You're welcome, Jess. Thanks for the feedback.

Leo Heuser
 
Top