Formula Help Counting Entries

Stephen --

The sample data seems to show 3 columns, while your description mentions 2 columns. Care to elaborate on what the data is & on what the expected result is?

Aladin

===========

sorry for not being clear

Sorry for not being clear columb b is what I want the answer to be

& what about...

column 3? That is apparently also data. I guess it doesn't matter what number is in A as long as it's either numeric or not empty, right?

======== Stephen -- The sample data seems to show 3 columns, while your description mentions 2 columns. Care to elaborate on what the data is & on what the expected result is? Aladin =========== : I am tryng to count the number of entries in column A And Put The Answer In Column B Depending which month they are in Some entries in column A are blank :

Aladin

Column A contains any number Column B is The Total I want And Column C is The Month

Hope This Is Clearer Aladin

Re: Aladin

OK, Stephen. Already worked out the case with C as housing data.

I'll assume the sample to start in row 2 and row 1 as empty.

In B2 array-enter: =IF(LEN(A2),MAX(($B$1:B1)*(ISNUMBER($B$1:B1))*($C$1:C1=C2))+1,0)

If you don't want to see zeroes appear in B, either custom format it as [=0]"";General or use the following array formula instead:

=IF(LEN(A2),MAX(IF((ISNUMBER($B$1:B1))*($C$1:C1=C2),$B$1:B1))+1,"")

I suppose you know how to enter an array-formula: Hit control+shift+enter together, instead of just enter.

Note. I hope you don't have too many rows of data, otherwise you'll experience a slow-down in performance.

Aladin

======== column 3? That is apparently also data. I guess it doesn't matter what number is in A as long as it's either numeric or not empty, right? ========

Re: Aladin

Fantastic Just Wanted Thank You For All Your Help