Add an additional lookup to this formula (sumproduct)

[jaspa]

Hi All,

I have this formula that gives me half of the value I need:

=SUMPRODUCT(--(TEXT(CSVData!F2:F65535,"mmyyyy")=TEXT(E2,"mmyyyy"))*(CSVData!K2:K65535="No"))

What I need to do now is add a lookup for town as well as the "No" value. so something like

=SUMPRODUCT(--(TEXT(CSVData!F2:F65535,"mmyyyy")=TEXT(E2,"mmyyyy"))*(CSVData!K2:K65535="No") + CSVDATA!L2:L65535="Town")

I have tried several variations, based on posts on the net but either get 00 or #N/A or #Value .

Any help much appreciated.

Jaspa

 

[Joe4]

Don't use "+", continue to use "*", i.e.

[COLOR=#333333]=SUMPRODUCT(--(TEXT(CSVData!F2:F65535,"mmyyyy")=TEXT(E2,"mmyyyy"))*(CSVData!K2:K65535="No") * (CSVDATA!L2:L65535="Town"))[/COLOR]