error in formula how to track

[alekha]

I used the below mentioned formula to sum the value if the chq date matches with the month mentioned in row 3 but I'm not able to get the required result attached is the draft


=SUMPRODUCT(($R$20:$R$600="CHQ DATE")*(TEXT($V$20:$BQ$600,"YYYYMM")=TEXT(V$3,"YYYYMM")),$V$9:$BQ$599)

Please let me know if the formula is wrong

[XLent]

as-is your SUMPRODUCT won't work given differences in the array dimensions, and current construct.

can you clarify which row(s) you wish to aggregate where the chq date (month) matches that of the header month
I don't believe it can be as written else it's circular (i.e. first calc resides in V9)

[alekha]

It was a typo actually I meant V19

=SUMPRODUCT(($R$20:$R$600="CHQ DATE")*(TEXT($V$20:$BQ$600,"YYYYMM")=TEXT(V$3,"YYYYMM")),$V$19:$BQ$599)

In R20 to R600 I run check for the string" CHQ DATE" when the string matches consider the YYYYMM and compare it with YYYYMM in Row 3 if matched the value in the cell above the matched cell will be added to the result

[XLent]

in which case the SUMPRODUCT is fine, e.g. if you have XL on manual calc, go to AH9 hit F2 + enter - you should get a number....

however, it seems you have circular references which may be causing you issues on Auto Calc- eg. S216/AK216

it's unclear if the circular references are desired, given references to Cash Flow this is possible, but just to reiterate the SUMPRODUCT, in and of itself, is fine.