Counting cells that fall within a date range and that are bolded

Hello,

I'm new to this forum and thanks in advance for any help I can get on this issue.

I have several worksheets I use to track information and one main worksheet which is my Monthly Report which pulls information from all the other worksheets automatically. On the Monthly Report worksheet, I have a cell that has the full name of the current month and another one that has the current year. I've got all the formulas on the Monthly Report set up to where I can change the month and/or the year and it will pull all the data from the other worksheets that correspond with that month/year.

One piece I am struggling with is trying to count cells from another worksheet that both (1) match the currently displayed month/year on the Monthly Report and (2) are in bold(the bold is to signify a certain status). I realize I may have to use VBA to accomplish this.

Here is an example:

On the Monthly Report worksheet, K2=November and N2=2018
I want to count all the cells in column E in Worksheet2 that contain dates that fall within the month of November 2018 and that are bold.

I have a good formula that I use in another cell that accomplishes the task of counting the dates by converting them to text and comparing them to K2 and N2. Here is what that formula looks like: =SUMPRODUCT(--(TEXT(Transitions!E26:E95, "mmmmyyyy")=K2&N2))

I just can't figure out how to add the second condition of those dates being bold as well.

I hope I've not sounded too confusing and appreciate any help I can get on this.

Thank you!

Hi

Can you tell us if there is a condition that dictates that the cell should be in bold?

If so that condition can be used for count, otherwise you need VBA.

In alternative make a column with a value 1 if the cell is bold or 0 if not and use that column in your formula.