Sumproduct Formula gives #REF! Error

[Benjamin2008]

Hi Everyone.


I have an attached sheet on the thread and looking some help to resolve sumproduct formula which gives error at the moment.

Basically , I need to count number of same printers and bring the results on to Sheet1 next to matching printer name.

Any Help Would be highly appraciated.

Thank you.

Ben

[Haseeb Avarakkan]

Hello Ben,

In B291 of Envanter sheet have a #REF! error, just delete that error, then will be OK

EDIT:

Since you are on Excel 2007, better to use COUNTIFS,

C3, then copy down.

=COUNTIFS(Envanter!B$2:B$500,B3,Envanter!A$2:A$500,C$2)

[Benjamin2008]

Hello Ben,

In B291 of Envanter sheet have a #REF! error, just delete that error, then will be OK

EDIT:

Since you are on Excel 2007, better to use COUNTIFS,

C3, then copy down.

=COUNTIFS(Envanter!B$2:B$500,B3,Envanter!A$2:A$500,C$2)

Dear Haseeb.

You Are Great Men. Problem solved now. Thank you very much for your help.

Best Regards

Ben

[AlKey]

Or with SUMPRODUCT

=SUMPRODUCT(--(Envanter!B$2:B$500=B3)*(Envanter!A$2:A$500=C$2))