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

"Jess" skrev i en meddelelse
...
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")


--
Best regards
Leo Heuser

Followup to newsgroup only please.

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" wrote:

"Jess" skrev i en meddelelse
...
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")


--
Best regards
Leo Heuser

Followup to newsgroup only please.

"Jess" skrev i en meddelelse
...
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