That worked! ----- Original Message ----- From: "RAJAT" <rajatagarwal@xxxxxxxxxxxxx> To: <accessindia@xxxxxxxxxxxxx> Sent: Saturday, February 04, 2006 11:01 AM Subject: [AI] Re: excel formulae again > Simple!!! > > Insert kitab! before c2:c37 also. > > formula will be: > sumif(kitab!b2:b37,"petrol",kitab!c2:c37) > > Rajat Agarwal > To unsubscribe from the list, please send a message to > accessindia-request@xxxxxxxxxxxxx with the subject "unsubscribe" without > the quotation marks. > ___________________________________________________________ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com To unsubscribe from the list, please send a message to accessindia-request@xxxxxxxxxxxxx with the subject "unsubscribe" without the quotation marks.