Excel formula help needed

[msc5195]

I created a check book in excel.

How do I get the row/column on sheet 4 to track the total from sheet 1 based on the month. Does this make any since? I can email file to some one if it will help.

Thanks

Robert

 

[NBVC]

Perhaps something like this should do it.

First change the Month headers in Sheet4 to their equivalent 3-letter abbreviations, eg. Jan, Feb, Mar, Apr,...etc.

Then use this formula:

=SUMPRODUCT(--(TEXT(CHECKING!$A$11:$A$500,"MMM")=C$6),CHECKING!F$11:F$500)

copied down and across