Working with data from two worksheets

[Guest]

Hi,

Can some one help me, please?

I am working with two worksheets - one a Summary Page which is a Pivot Table
and the other the data page which contains the information for the pivot
table.

In one of the fields in the Summary page, I would like to transfer the total
of all items that have a value greater than today's date. I need the system
to identify all transactions that are dated greater than today and then pick
out the repsective amounts for each of this rows, add them up and populate
back into the Summary page.

Thanks and regards,
Nithya

 

[Guest]

Put this formula in the cell that you want the totals to read into
Then just edit the formula to your needs

=IF(Sheet1!B1>Sheet1!A1,Sheet1!A10,"")

Sheet1!B1 = the date that could be greater than
Today's Date =Sheet1!A1 ,
and if it is, then copy =Sheet1!A10
if not, then leave blank