1 Visitor Messages

  1. Haggai
    I have a workbook with many sheets. there are tables in two differents sheet and i refer to a column of the first table in some cell on the other table on another sheet but when I drag the cell to copy the formula it changes the column too. is there a way to give the column an absolute reference?
    here is my formula
    =SUMPRODUCT((Table5[Date]=Presence!$A2)*(Table5[Haut M]=Presence!D$1)*(Table5[H/M]))
    thank you
Showing Visitor Messages 1 to 1 of 1
About Haggai

Basic Information


Date of Birth
November 9, 1959 (52)
About Haggai
Location:
Narbonne,France
My Microsoft Office Version:
Excel 2007

Statistics


Total Posts
Total Posts
3
Posts Per Day
0.00
Last Post
absolute reference in tables 11-17-2009 04:32 AM
Visitor Messages
Total Messages
1
Most Recent Message
11-16-2009 11:27 AM
General Information
Last Activity
02-25-2010 07:08 AM
Join Date
04-13-2009

Search Engine Friendly URLs by vBSEO 3.2.0