Need Google Sheets Formula Help

[RhinoKS]

Hey There,

I need to create a formula for the below. Does anyone know how I would go about this ?

I need to come up with a sum in % of Column E with these parameters.

count if Column I is Greater than Column H as well as if Column I is blank to use "Today's" date but not fill the cell with Today's date.

 

[mamady]

Hi Dear,

Please check if the below formula satisfies your requirement:

=SUMIF(OR(I6>H6,ISBLANK(I6)),TRUE,E6)/Sum(E:E)

Regards
Yusuf

 

[RhinoKS]

Thanks Yusuf,

I am not great with the formulas, but I think currently this formula would count all blank cells, I need it to only count the blank cells if the column H is less than the current "todays" date

 

[mamady]

Hi Dear,

Noted, please find the below updated formula:
=SUMIF(OR(I2>H2,AND(ISBLANK(I2),H2<TODAY())),TRUE,E2)/Sum(E:E)

it can be illustated as per the attched screen-shot (covering all scenarios).

Regards
Yusuf