Unable to use cell for reference which has formula -- Please advie

[anjanreddy]

I have one coloumnA with formula =IF(F4="","",(H4-F4)) ------ the result I want to use for reference in which I am unable to use the result value using below formula.
I have one more cell B with month & date

Currently using formula =SUMPRODUCT((TEXT(A4:A1501,"mmmyyyy")=$B4&$C4)*('Credit Cards&Loans Transactions'!J4:J1501))
Cell B4 has month & C4 has year.

J4:j1501 cell has the formula "=IF(F4="","",(H4-F4)) " , I want to use the result of cell in above formula.

Please advice, Any help would be appreciated.

[FDibbins]

Without seeing a (clean) sample of what you are working with, and what you are trying to do, its hard to say what is going wrong here

[anjanreddy]

Actually I have a spreadsheet with two tabs sheets - once has data and another produce stats.

->data tab has following coloums
A coloumn has month and year information in formate - "mmmyyyy"
H coloumn has EMI data -- eg: 1000$
F coloumn has Intrest data -- eg: 100$
J coloumn has Principal clearing data with formula "=IF(F4="","",(H4-F4))" which gives me result $900 cleared from above example data in H& F

column.

This tab sheet works fine for calculation. But having problem in Stats tab sheet.

-> Stats tab sheet has following coloumn/row which is giving "#VALUE!" error.

> Decription Cell : The row which has description is "Total Principal Cleared for the period"
> Problem cell : The row result cell G12 in stats tab sheet is giving error "#VALUE!" has formula "=SUMPRODUCT((TEXT('Credit Cards&Loans

Transactions'!A4:A1501,"mmmyyyy")=$B4&$C4)*('Credit Cards&Loans Transactions'!J4:J1501))"

> Cell B4 has Month drop down list and C4 cell has year drop down list. Using both cell I want to select month and year to get the stats from

data tab sheet "A" coloumn A4:A1501 range.

> Purpose of stats tab: when I select month and year from in the B4 & C4 cell I want to sum the amount from J4:J15011 cell range for selected

month and year. Each cell J4:J15011 has formula "=IF(F4="","",(H4-F4))".


I believe the error I am getting in the result cell (G12- in Stats tab) is because the cell is refering to formula in "J4:J1501" cells not the

result of the cell. which suppose to refer the result amount so the sum amount (principl amount) of the selected month and year is displayed in

G12 cell in stats tab sheet.

Please advice for solution, Any help would be appreciated.

[AliGW]

Can you not attach the Excel workbook here? It would make helping you a lot easier.