Ignore the value in summation, when adjacent cells are blank

[dastgir]

Dear All,

In attached file, how to arrive at actual results ie sum is effected in column B when there is corresponding value in column C.

Rgds

Dastgir

[mangesh.mehendale]

hiii try this...

Array formula required Ctr+Shift+Enter

Please Login or Register  to view this content.

[dastgir]

What if the cells are blank ie there is no "awaited" mark there.

Rgds,

Dastgir

[dastgir]

Also you forgot the denominator, which is critical part of this query.

Rgds,

Dastgir

[mangesh.mehendale]

you have mentioned only about Summation... ok then try this...

Please Login or Register  to view this content.