Problem with SUMPRODUCT formula.
 

Can anyone tell me what is wrong with the following formula?

=SUMPRODUCT((L9:L1000="O/D")*(H9:H1000)*(M9:M1000=$C$6))

The formula seems to work Ok until I add the last part (M9:M1000=$C$6).

Cell $C$6 contains a date. Essentially I am total the items in column H
which are "O/D" on a particular date (C6).

The result I am getting is #N/A.

As usual I appreciate any help given.

Thanks,

Andrew.

Problem with SUMPRODUCT formula.
 

It may be something wrong with the dates because it works fine for me.

"Andrew Mackenzie" wrote:

Can anyone tell me what is wrong with the following formula?

=SUMPRODUCT((L9:L1000="O/D")*(H9:H1000)*(M9:M1000=$C$6))

The formula seems to work Ok until I add the last part (M9:M1000=$C$6).

Cell $C$6 contains a date. Essentially I am total the items in column H
which are "O/D" on a particular date (C6).

The result I am getting is #N/A.

As usual I appreciate any help given.

Thanks,

Andrew.

Problem with SUMPRODUCT formula.
 

are any of the values in M9:M1000 equal to #N/A?

In article ,
"Andrew Mackenzie" wrote:

Can anyone tell me what is wrong with the following formula?

=SUMPRODUCT((L9:L1000="O/D")*(H9:H1000)*(M9:M1000=$C$6))

The formula seems to work Ok until I add the last part (M9:M1000=$C$6).

Cell $C$6 contains a date. Essentially I am total the items in column H
which are "O/D" on a particular date (C6).

The result I am getting is #N/A.

As usual I appreciate any help given.

Thanks,

Andrew.

Problem with SUMPRODUCT formula.
 

Thanks Guys.

Spot on JE. Couldn't see the #N/As in column M because errors were
conditionally formatted to be invisible.

Cheers,

Andrew

"JE McGimpsey" wrote in message
...
are any of the values in M9:M1000 equal to #N/A?

In article ,
"Andrew Mackenzie" wrote:

Can anyone tell me what is wrong with the following formula?

=SUMPRODUCT((L9:L1000="O/D")*(H9:H1000)*(M9:M1000=$C$6))

The formula seems to work Ok until I add the last part (M9:M1000=$C$6).

Cell $C$6 contains a date. Essentially I am total the items in column H
which are "O/D" on a particular date (C6).

The result I am getting is #N/A.

As usual I appreciate any help given.

Thanks,

Andrew.