adding rows only if two cells blanks

[bwiebe]

Jak 11/05/2011 $50,000.00 $0.00
07/12/2012 $10,000.00 $0.00
$60,000.00 $0.00
In the example above, I want to add Jak's 3rd row only, and many more "third row situations" down the page. I tried =SUMIF(A3,"isblank",c3:d3) but only received ) as a result. I feel I am close, but no cigar. any advice?

[dilipandey]

Hi bwiebe,

welcome to the forum.
Can you upload the data in excel so that data arrangement can be seen easily also what criteria you are following .. is it the sum of previous two (like subtotal) ?

Regards,
DILIPandey
<click on below * if this helps>

[bwiebe]

sample for how to add row with two blanks only.xlsx

I am new at this. I have tried to attach a file. The x marks where I would like to put a formula.

[dilipandey]

Okay.. may be below formula in F2 and drag down:-

Please Login or Register  to view this content.

sample for how to add row with two blanks only.xlsx


Regards,
DILIPandey
<click on below * if this helps>