Need Formula

[GouravKumar]

I need a formula to get the given output

 

[Hany ali]

don't wait any Helping without the file !!!!

 

[GouravKumar]

Thanks Hany for your suggestion

 

[Asheesh]

Hi, See the blue highlighted cells..

 

[herofox]

hi

 

[GouravKumar]

Hi Herofox, Thanks for the help. but i need a single formula or all the output.

 

[Asheesh]

try this..

SUMIFS($D$2:$D$11,$A$2:$A$11,IF(G2="","<>?",G2),$B$2:$B$11,G3,$C$2:$C$11,IF(G4="","<>?",G4))

 

[herofox]

why single formula ,if the Result Right ?!!!!!
Thanks Mr Asheesh ,Very Nice formula

 

[Asheesh]

@herofox glad you like it. Normally, single formula solutions are used to avoid duplication of work which saves time as one doesn't need to type or edit the fourmlae repeatedly. Plus, in many scenarios it offers dynamic & robust solution.

 

[GouravKumar]

try this..

SUMIFS($D$2:$D$11,$A$2:$A$11,IF(G2="","<>?",G2),$B$2:$B$11,G3,$C$2:$C$11,IF(G4="","<>?",G4))

Hi Asheesh,

Your formula almost solved my problem but a little help i need from you.

When i am removing "Section" it is showing 0 (Zero)

Please check in attachment.

 

[bosco_yip]

A bit modified Asheesh's formula

In G6, enter formula and copied to J6 and M6 :

=IF(COUNTA(G2:G4)>0,SUMIFS($D:$D,$A:$A,IF(G2="","<>",G2),$B:$B,IF(G3="","<>",G3),$C:$C,IF(G4="","<>?",G4)),"")

Regards
Bosco

 

[GouravKumar]

A bit modified Asheesh's formula

In G6, enter formula and copied to J6 and M6 :

=IF(COUNTA(G2:G4)>0,SUMIFS($D:$D,$A:$A,IF(G2="","<>",G2),$B:$B,IF(G3="","<>",G3),$C:$C,IF(G4="","<>?",G4)),"")

Regards
Bosco

Thanks Bosco this formula is as working as i want.

Thanks for the solution.