Countif - Stock Trading Template Tracking

Okay – One more time me bothering you folks, I hope.

On Worksheet 2 of the attached document, I want to work out some sort of “COUNTIF” formula that reflects 2 conditions. (I have searched the net and can’t seem to get anything concrete happening.)

On Cell B9 of worksheet 2, how do I get it to reference Column A of worksheet 1, as relates ONLY to Jun entries AND as it further relates to whether or not the letters “DT” appear in column C (of worksheet 1)?

Cell B9 of worksheet 2 should, to reiterate, only summarize figures that are from Jun and were day trades (DT – per column C, worksheet 1).

Once again, if I have the syntax on the one cell, I’ll utilize it for the other ones as well.

Thanks again for your insight.

Somebodyhadto

Hi again.

The results on the 2nd worksheet are showing as accumulated 'days' but what is needed in B9 is the accumulative profits (as total June dollar figures) occurring for June, while still referencing the data in the C-Column of worksheet one.

The result should show in B9 of worksheet 2 as the accumulative dollars from L5 and L7 of worksheet 1. This reflects how much, in June, the 'Day Trading' (or 'DT') profits were.

Hope this clarifies. But great formula and definitely on the right track! Thanks so much!

Somebodyhadto