=IF($B$3:$B$22=$M4,SUMPRODUCT(--($H$3:$K$12=1)),SUMPRODUCT(--($H$13:$K$2
2=1)))
Dear Group,
Please explain in short or little elaborate and tell.
Regards,
Muneer,
CC...
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
Dear Muneer,
Please share a sheet where it is using.
On Wed, Sep 19, 2012 at 3:47 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
=IF($B$3:$B$22=$M4,SUMPRODUCT(--($H$3:$K$12=1)),SUMPRODUCT(--($H$13:$K$22=1)))
** **
Dear Group,
** **
Please explain in short or
hi
=IF($B$3:$B$22=$M4,SUMPRODUCT(--($H$3:$K$12=1)),SUMPRODUCT(-
-($H$13:$K$22=1)))
For each cell in range in B3 to B22 if it is equals to m4 then ...
If True: here for each cell in range H3 to K12 if cell is equal to 1 then
give sum of all cells which is equal to 1..
If False: here for each
Dear Noor,
Thanx for u r help.
I come to know about this before itself, my question directs you to
glance my knowledge.
I don't have anything now to do with it but if I have anything later.
It doesn't bear any urgency only for clarification.
Regards,
Muneer,
CC...
--