Arrays/Functions/Different datatypes in a formula?

[Guest]

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

 

[Leo Heuser]

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

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")

 

[Guest]

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.

 

[Leo Heuser]

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.

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

Leo Heuser