Hello guys,

i am searching a formula similar to sumifs but i need it for the following:

i have some columns that are not one after each other and i want to sum the values in each row only from the cells in these particular columns and only if cell other column is BLANK...
For example:
i have columns S, AE, AQ, BC and BO. I want to sum the row 5 only if columns U(condition for column S), AG(condition for column AE), AS(condition for column AQ), BE(condition in column BC) and BQ(condition for column BO) are BLANK.

In other words I need sum of column S(only if column U is blank)+column AE(only if column AG is blank)+ etc....

Thanks in advance!