Count At_Kt as 1 if subject Mark is less than 40 and calculate total nos of At_Kts. Eg: If any student has less then 40 marks in 2 Subject then ATKT count is 2 ,If any student has less then 40 marks in 3 subject then ATKT count is 3 .......not get result

[sohil_bagwan]

MarksheetTask Data.xlsx (12.8 KB)

[purnima_mandan]

Marksheet Data .xlsx (14.4 KB)
Main (5) (1).xaml (64.4 KB)

in that main file your doubt was cleared

[RajKumar_DC (RajKumar Durai)]

Hi @sohil_bagwan,

What about this workflow

Workflow

Xaml
Main (1).xaml (9.9 KB)

If(CInt(row(“English”).ToString)>40,0,1)+
If(CInt(row(“Urdu”).ToString)>40,0,1)+
If(CInt(row(“Physics”).ToString)>40,0,1)+
If(CInt(row(“Math”).ToString)>40,0,1)+
If(CInt(row(“Chemistry”).ToString)>40,0,1)+
If(CInt(row(“Biology”).ToString)>40,0,1)

Thanks,
Rajkumar

[sohil_bagwan]

Thanks Mam

[sohil_bagwan]

Thanks RAJ

[purnima_mandan]

you got the output ?

[sohil_bagwan]

can we use modern excel activity without linq