Help in SUMIF Formula

[PRIMA]

Hello Everyone,

Can anybody please help in the attached image below:

I want to get the actual result in Column H when adding the Column I.

Many thanks

 

[PRIMA]

Hello Everyone,

Can anybody please help in the attached image below: Sorry I forgot the to attach the image.

I want to get the actual result in Column H when adding the Column I.

Many thanks

Regards.

 

[Sumitpal SIngh Sandhu]

Hello,
Try this ,
=IF(A2="",SUM(A3:INDEX(A3:A99,MATCH(TRUE,(A3:A99=""),0),0)),A2)
after entering the formula just press Ctrl+Shift +Enter

Hope it helps

Enjoy

Regards
Sumit Sandhu

 

[PRIMA]

Hi Sumit Sandhu,

Thank you so much for your quick response. However, I am sorry it does not work.

What I want is to sum up the Column I and the result from J3, J4, J5, J8, J13, J19, J20, J23, J27, J31 and J32 should match in Column H with same rows, H3, H4, H5, and etc.

Thanks and regards.

 

[PRIMA]

Hi Sumit Sandhu,

Thank you so much for your quick response. However, I am sorry it does not work.

What I want is to sum up the Column I and the result from J3, J4, J5, J8, J13, J19, J20, J23, J27, J31 and J32 should match in Column H with same rows, H3, H4, H5, and etc.

And the rest of values in Column I, such as, I6, I7, I9, I10, I11, I12 and etc. shall remain as is and/or the same figures.

Thanks and regards.

 

[PRIMA]

Thank you so much for your help Sumit Sandhu.

I have got it. The Formula should looks like this:

={IF(F3="",SUM(F3:INDEX(I3:$I$99,MATCH(TRUE,(F3:F$99=""),0),0)),I3)}

Again, many thanks

 

[Sumitpal SIngh Sandhu]

Yes ,if after entering the formula if you just press (ctrl + shift + enter) u will get this auto

Welcome mate!!

 

[PRIMA]

Hi there,

I tried to use this formula: {=IF(F3="",SUM(F3:INDEX(I3:$I$99,MATCH(TRUE,(F3:F$99=""),0),0)),I3)}, however, it sum up all the numbers in Column H as shown in below image: What I want is a formula that sum up the Column I in each corresponding blank Cells:

Many thanks.

 

[Sumitpal SIngh Sandhu]

{=if(i2="",sum(i3:index(i3:$i$99,match(true,(i3:i$99=""),0),0)),i2)}

 

[PRIMA]

Hi Singh,

Sorry but it doesn't work. any other formula that can meet my requirements. Thank you