If true +1

[lucraft]

Hi,

Apologies, but I couldn't find anything on this, mainly because i didnt know what to search for!!

I have the following in column A;

=IF(AND($F3='Surveyor Summary'!$C$2,($G3>='Surveyor Summary'!$C$3)*($G3<='Surveyor Summary'!$C$4)),1,0)

(Column F contains a company name, Column G contains a date - the Summary sheet has criteria relating to these [Company Name, From date, To date]).

The above works, and returns 1 each time it is true. How can I adapt the formula so that each TRUE value has a higher number (1, 2, 3, 4 and so on?).

Thanks
Lucraft

[mhuston]

Hi,

Apologies, but I couldn't find anything on this, mainly because i didnt know what to search for!!

I have the following in column A;

=IF(AND($F3='Surveyor Summary'!$C$2,($G3>='Surveyor Summary'!$C$3)*($G3<='Surveyor Summary'!$C$4)),1,0)

(Column F contains a company name, Column G contains a date - the Summary sheet has criteria relating to these [Company Name, From date, To date]).

The above works, and returns 1 each time it is true. How can I adapt the formula so that each TRUE value has a higher number (1, 2, 3, 4 and so on?).

Thanks
Lucraft

Insert a sample of data.

[NBVC]

Assuming that formula is in A3, then try:

=IF(AND($F3='Surveyor Summary'!$C$2,($G3>='Surveyor Summary'!$C$3)*($G3<='Surveyor Summary'!$C$4)),MAX($A$1:$A2)+1,0)

copied down

[lucraft]

Assuming that formula is in A3, then try:

=IF(AND($F3='Surveyor Summary'!$C$2,($G3>='Surveyor Summary'!$C$3)*($G3<='Surveyor Summary'!$C$4)),MAX($A$1:$A2)+1,0)

copied down

Thats brilliant, thanks!

It works well and is soooo simple now that I see it!