| View previous topic :: View next topic |
| Author |
Message |
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
 Posted: Tue Jan 26, 2010 2:18 am Post subject: read a number according to given date (solved) |
 |
|
I have two long columns
Col A is dates
Col B numbers
I need an array that reads a date (entered in C29) from Col A and displays the number from the adjacent cell in column B in C2.
Using the Wizard and the Array button on
C2=(A40:A600=C1);(b40:b600)
and it doesnt work
_________________
carl
Using OpenOffice.org 2 on XP sp2
Last edited by carl on Wed Jan 27, 2010 6:38 am; edited 1 time in total |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1845
Location: Sydney, Australia
|
| Posted: Tue Jan 26, 2010 2:27 am Post subject: |
|
|
=SUMPRODUCT(A40:A600=C29;B40:B600)
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
|
