Count the number of wet days following a dry day..

Hi!

Can somebody please help to determine which formula works best for my spreadsheet?

Okay so here's an example of what my data set looks like.

1111.JPG

I want to create a formula which could count the number of wet days following a dry day.

So, in this case, the answer should be 3, only counting A4, A7 and A14.

Or if in case I would like to count the number of wet days following a wet day, the answer should also be 3.
In this case, the A5, A8 and A9 cells should only be counted.

I hope someone can help me on this one.. It's too confusing and I'm not an Excel expert too.

Thanks!

Originally Posted by Jacc

Like this? Random numbers for the purpose of testing, hit F9 to renew. Three formulas, the one in the middle is array, have to be entered with Ctrl + Shift + Enter. Note that the ranges are offset one cell.

The random numbers were so cool! I didn't know that Excel could do that!

Anyway, I also know about that IF AND function.. However, I was actually hoping there's no need for me to create several columns for that~

here's my file~^^

I've tried using your formulae but it seems like it's not quite working for me..

Originally Posted by playaller

Hello ayskriim,

please see the attached sheet:

I think it's almost right. I'm sorry if my excel file was a bit wrong.. I revised it..

I was hoping that you can help me determine the count for every month.

Originally Posted by hemesh

in H4 copy paste below then hold control and shift together and then hit enter Drag up to first december
=SUMPRODUCT(IFERROR(--(TEXT($B$3:$B$367,"MMM")=$G4)*($D$3:$D$367=0)*($D$4:$D$367>0),0))

BRILLIANT!!!! Thanks a lot!!!!!!!^^

The people here are so awesome!

Thanks a lot for helping me~^^

Originally Posted by hemesh

You are welcome and Thanks for the feedback !

My pleasure! that was brilliant! but if it's okay to ask one more thing, how can i count the number of wet days following a wet day?