Required IF AND Formula for 3 conditions with Selected Cells......

[Mohan BR]

Dear Team

Kindly Refer attached file,

Request you to Provide the Formula or Solution, Already formula Mention the Red Colored Cell (C9) if I Select Cell B2 as ROB than C2 as Zone Total I Need a formula for Zone Total.

Thanks in Advance

Regards
Mohan

 

[Nebu]

Hi:

May be something like this?

Thanks

 

[Mohan BR]

Dear Nebu,

Thank so Much for your Response.
Given formula working Fine, But if I Select Cell B2 as ROB, C2 as ASM Name Example "Abdulla", its Showing Zero. I need actual Output of "Abdulla" and Other ASM's.
Request you to do the Needful.

Regards
Mohan

 

[bosco_yip]

Maybe....

In "Format sheet" C9, formula :
(based on post #.1 formula, changed part in highlighted red color)

=IF($B$2="ROB",SUMIFS('KTK Master'!H:H,'KTK Master'!$G:$G,IF($C$2="Zone Total","<>",$C$2),'KTK Master'!J:J,"Yes"),SUMIFS('KTK Master'!H:H,'KTK Master'!$D:$D,$C$2,'KTK Master'!$J:$J,"Yes"))


Regards