Dear Sir
I have the following VBA formula
Code
"=SUMPRODUCT(--(data!R5C1:R" & lngEndRow & "C1=RC3)*--(MONTH(data!R5C2:R" & lngEndRow & "C2)=MONTH(9)))"
I have a combobox in which all twelve months are mentioned in words (January, February, March etc)
Is there a way in which the formula calculates the data pertaining to the month selected in the combobox so that I do not have to write 12 different formulas.