uber.metal
New Member
- Joined
- Nov 21, 2005
- Messages
- 5
Here it is. I have 4 columns of information that can be entered at random on a data sheet. I also have a running statistics sheet which has formulas on it to show information from the data sheet. 3 of the columns are dates, one is a number which can be entered as any number.
I was able to make my own formula to show if some rows in column a = "date" then add up all rows that match "date" in column b.
I now need to incorporate the other 2 date fields to filter the results.
Effectively - if column a is equal to or less than "date" and column c = "NULL", then do the same as before.
Also - if column a is equal to or less than "date" and column c = "date" and column d = "NULL" then same as before.
The date has to be able to be any date and so does the number. Any help would be greatly appreciated as i was unable to find anything about this in search.
I was able to make my own formula to show if some rows in column a = "date" then add up all rows that match "date" in column b.
I now need to incorporate the other 2 date fields to filter the results.
Effectively - if column a is equal to or less than "date" and column c = "NULL", then do the same as before.
Also - if column a is equal to or less than "date" and column c = "date" and column d = "NULL" then same as before.
The date has to be able to be any date and so does the number. Any help would be greatly appreciated as i was unable to find anything about this in search.