i have different work sheet in one work book contains dates and figurs. i want to make formula if dates in the work sheet sells = the date in basic sheet sell then add up certain cells.
My formula is :
=if(or( eomonth(monthset1990!e10,monthse1990!q10),(monthset1991!e,monthset1991!10,q10)=f7,(sum(monthset1991!f11,monthset1991!q11),or,(monthset991!f11,monthset1991!q11),0))
but not working
please advice