I imran khan New Member Jul 16, 2012 #1 lets suppose i have 2 column "A" and "B" and i want to add only those value from Column "B" which has text. A B 12 q 14 15 a 15 e 15
lets suppose i have 2 column "A" and "B" and i want to add only those value from Column "B" which has text. A B 12 q 14 15 a 15 e 15
N NARAYANK991 Excel Ninja Jul 16, 2012 #2 Hi Imran , Try this : =SUMPRODUCT((A2:A6)*ISTEXT(B2:B6)) Narayan
I imran khan New Member Jul 16, 2012 #3 thanks naryan it works... so nice of u ... please i have one more post and please also solve that problem.. thanks and regards
thanks naryan it works... so nice of u ... please i have one more post and please also solve that problem.. thanks and regards