"easy question" ?
Hi I got trouble with this one....
in row a5:iv5 I got an "date" value...
in row a20:iv20 I got an ordernary value...
in another sheet I wanna sum up the value of a20:iv20 if I got the right date...
example "sheet" 2 got an date in a5= 25.08.2007
then in sheet 1 I wanna sum up al values in row a20.iv20 if the date is correct??
hopefully someone understand my question.....
Good afternoon fiur
How about :
=SUMIF(A5:IV5,(Sheet2!A5),A20:IV20)
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Try
=SUMIF(Sheet1!A5:IV5,A5,Sheet1!A20:IV20)
where Sheet1 is the name of your sheet containing the data to sum
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
thanx for your help but when I use your formulas I get #Name ?
I got it right now...
=SUMMERHVIS('Sit and go tur.'!H4:Z4;F4;'Sit and go tur.'!H20:Z20)
Last edited by fiur; 08-30-2007 at 10:22 AM.
Did you change the sheet name to match yours. And add an "!" mark after the name and before the range?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks