Hi,

I am using a formula here,

=IF((SALARY!$G10=""),(SUMPRODUCT((SALARY!$F$10:$F$1026>=C10)*(SALARY!$F$10:$F$1026<=EOMONTH(C10,0)),SALARY!$Q$10:$Q$1026)),((SUMPRODUCT((SALARY!$G$10:$G$1026>=C10)*(SALARY!$G$10:$G$1026<=EOMONTH(C10,0)),SALARY!$Q$10:$Q$1026))))

This formula does not work properly. here are numbers in column Q and Date in column C,G and F.

Please help,

regards

When I use this formula with the help of other cells it gives correct answer. I use  "=IF(G10<>"",G10,F10)" in column AC10 then I use

"=SUMPRODUCT((SALARY!$AC$10:$AC$1026>=C10)*(SALARY!$AC$10:$AC$1026<=EOMONTH(C10,0)),SALARY!$Q$10:$Q$1026))". The result is, though most of the time but not always similar when it is used as

"=IF((SALARY!$G10<>""),((SUMPRODUCT((SALARY!$G$10:$G$1026>=C10)*(SALARY!$G$10:$G$1026<=EOMONTH(C10,0)),SALARY!$Q$10:$Q$1026)),(SUMPRODUCT((SALARY!$F$10:$F$1026>=C10)*(SALARY!$F$10:$F$1026<=EOMONTH(C10,0)),SALARY!$Q$10:$Q$1026))))"

please help.