Thank you sir
Regards,
Sanjib
On Sat, Oct 6, 2012 at 8:46 PM, ashish koul koul.ash...@gmail.com wrote:
visit
http://www.excelbanter.com/showthread.php?t=182549
On Sat, Oct 6, 2012 at 2:22 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Noorain Ansari,
Would you
Dear Sanjib,
-- is an unary operator, without using it, Formula revert TRUE,TRUE or
TRUE,FALSE.
We can't sum it because it is Text, -- convert it in values like 1,1 or 0,0,
We can also use instead of --
1. 1*
2. 1^
3. 0+
4. /1
Hope you will understand,
On Sat, Oct 6, 2012 at 2:22 PM,
Dear Noorain Ansari,
Would you please tell why have you used the -- sing in the formula. for
you reference i have highlighted
the portion..
*=SUMPRODUCT(**--**(B4:B14=Karthik)*($C$4:$C$14=Collected))*
Thanking you
Regards,
Sanjib
--
-
--
Join official facebook page of this forum @
visit
http://www.excelbanter.com/showthread.php?t=182549
On Sat, Oct 6, 2012 at 2:22 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Noorain Ansari,
Would you please tell why have you used the -- sing in the formula. for
you reference i have highlighted
the portion..