Conditional Sum

[achu]

Dear sir,

I hope doing well,

Project Name vakas = vakas, ve-ne24-...,ve-se5-...
Project Name Galaxy = Galaxy-1,Galaxy-2

i need total payment of reporting

if my reporting amount count only :- Total,interest, infra , mseb charges,legal, grill


please help me this formula


Thanks,
Achyutanand

 

[vletm]

@achu
Could You find Your needs from this?

 

[achu]

no i need array formula like =sum((F2:F32+I2:I32+J2:J32+K2:K32+M2:M32+O2:O32)*(--(A2:A32="Sold")*(B2:B32={"Vakas","*VE-NE24*","VE-SE5*") = Vakas

=sum((F2:F32+I2:I32+J2:J32+K2:K32+M2:M32+O2:O32)*(--(A2:A32="Sold")*(left(B2:B32,3)="Gal") = Galaxy

but i am not completed formula for vakas

 

[Khalid NGO]

no i need array formula like =sum((F2:F32+I2:I32+J2:J32+K2:K32+M2:M32+O2:O32)*(--(A2:A32="Sold")*(B2:B32={"Vakas","*VE-NE24*","VE-SE5*") = Vakas

=sum((F2:F32+I2:I32+J2:J32+K2:K32+M2:M32+O2:O32)*(--(A2:A32="Sold")*(left(B2:B32,3)="Gal") = Galaxy

but i am not completed formula for vakas

Hi @achu,
I am not sure but is this you are looking for?

Make a helper column say Column P, Enter this in P2:
=F2+I2+J2+K2+M2+O2
Copy down till P32

This in R4:
=SUMIFS($P$2:$P$32,$A$2:$A$32,R$3,$B$2:$B$32,"*"&LEFT($Q4,1)&"*")
Copy down and across

Regards,

 

[Deepak]

achu

It would be better if you share what's the short form[gal =galaxy &
Vakas/VE-NE24/VE-SE5=Vakas] u may use to get the same as well as also share the expected output in excel.

 

[achu]

sorry no sort form in this logic

 

[Deepak]

sorry no sort form in this logic

I mean to say, how will excel decide that which project data needs to be clubbed.

 

[achu]

VE-NE24-(Number) & VE-SE5-(Number) will decide vakas
Galaxy-1,Galaxy-2 Decide Galaxy

 

[Deepak]

Expected result ?