| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula
=IF($A$2=$B$2,'1st Shift'!$D$7,0)
A2=cell on yearly sheet B2=cell on yearly sheet (for month of year =January) On 1st shift sheet D7=month of year I need to track data from the 1st shift sheet by month on the yearly sheet. when I change the month in D7 1st shift sheet and replace with another month I loose the data on the Yearly sheet |
Threaded Mode
