Hi,
I'm a basic excel user and am out of my depth constructing some formulas!
I have a workbook to record yearly bird sightings. Each month is on a separate sheet, with a summary sheet at the beginning.
I want to compare data on the same row between sheets, and record if the cell is filled and if the corresponding row in previous sheets is blank; ie if this is the first month we have a record for the bird.
I have tried
=IF('Jan 13'!B2="", 'Feb 13'!B2="", 'Mar 13'!B2="", 'Apr 13'!B2="", yes, no)
=IF('Jan 13'!B2=<0, 'Feb 13'!B2=<0,'Mar 13'!B2=<0, 'Apr 13'!B2=<0,yes, no)
=AND(B2>0, 'Jan 13'!B2="", 'Feb 13'!B2="", 'Mar 13'!B2="", 'Apr 13'!B2="")
I then want to count how many positive records were returned; ie total new species seen that month, and copy the data to the summary sheet, but I can do this manually.
Alternatively, if there is a way or it is easier to do the same thing on the summary sheet; count if the cell is filled and the left hand cells are all blank, down a column, then that would work too.
ANY help would be much appreciated. I currently do this by hand for 172 rows!
Attached is a simplified version of my spreadsheet. sample bird records.xlsxsample bird records.xlsx
Many thanks
Bookmarks