Sum Product

[paulcherianc]

Dears,

Following formula is giving "Value" error. Can you please fix my issue.

=SUMPRODUCT(--(X$3:BL$3=S1),A$4:A$49,AH$4:AH$49)

I have attached a sample file for your review.

Thanks in Advance!

 

[Asheesh]

hey @paulcherianc

Can you please explain the purpose of matching the date in cell S1 with header in X3:BL3 and then selecting the column AH individually.

 

[NARAYANK991]

Hi ,

I think the formula should be :

=SUMPRODUCT(((X$3:BL$3=S1)*X$4:BL$49) * A$4:A$49)

Narayan

 

[paulcherianc]

It's working perfectly. Can you please help me to fix the currency as stated on the new attached file.

Thanks in advance!

 

[paulcherianc]

hey @paulcherianc

Can you please explain the purpose of matching the date in cell S1 with header in X3:BL3 and then selecting the column AH individually.

This is for automatic calculation when we change each month head.

 

[NARAYANK991]

Hi ,

The data has only the QAR currency ; the cell which relates to EUR will obviously be 0.

Will your data have a mix of currencies ?

Narayan

 

[paulcherianc]

Yes. My main file contains mix of currencies.

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[paulcherianc]

Wonderful! Thanks a lot, Narayan!!!