Thanks very much Ashish Ji & Zafar
Regds
ROHAN
On Tue, May 10, 2011 at 9:30 PM, ashish koul wrote:
> to find total ---
>
>
> =INDEX($C$12:$K$12,0,MATCH($N$2,$C$2:$K$2,0))
>
>
>
>
> On Tue, May 10, 2011 at 5:39 PM, Rohan Young wrote:
>
>> Thanks Ashish Ji,
>>
>> as i knew that i will g
to find total ---
=INDEX($C$12:$K$12,0,MATCH($N$2,$C$2:$K$2,0))
On Tue, May 10, 2011 at 5:39 PM, Rohan Young wrote:
> Thanks Ashish Ji,
>
> as i knew that i will got the answer first from your side, but 1 more
> thing if i do not have column A (skilled & unskilled type), in that
>
Thanks Ashish Ji,
as i knew that i will got the answer first from your side, but 1 more thing
if i do not have column A (skilled & unskilled type), in that situation what
is the formula?
please reply
Thanks & Regds
ROHAN
On Tue, May 10, 2011 at 5:16 PM, ashish koul wrote:
> =SUMPRODUCT(--($
Subject: $$Excel-Macros$$ Total of sum of Diff. criteria according to date
Dear Experts,
Daily updation of the status according to skilled & unskilled type labour, I
need a total sum of skilled & unskilled if I change the date only. because
total sum of these diff. criteria is use
try this
type:--
n4= =SUMPRODUCT(--($A$3:$A$11=M4)*($C$2:$K$2=$N$2),($C$3:$K$11))
n5= =SUMPRODUCT(--($A$3:$A$11=M5)*($C$2:$K$2=$N$2),($C$3:$K$11))
On Tue, May 10, 2011 at 11:17 AM, Rohan Young wrote:
> Dear Experts,
>
> Daily updation of the status according to skilled & unskilled type l
Dear Experts,
Daily updation of the status according to skilled & unskilled type labour, I
need a total sum of skilled & unskilled if I change the date only. because
total sum of these diff. criteria is use in some other different formats.
Sample file attached (for better understanding)
thanks &
