Countif help please

[hammerjames92]

Hi, seeking some help please - I got data set as above, I want to put into a simple summary table and chart:

Problem is my "real build week" will actually change over time and needs constantly updating so I want a formula to add up the number of engine ranges in a particular month without me having to manually check it

I think I need a =Countif formula in this chart so I can use it on a criteria by engine range type and then by build month? I think I am close but can't work out

Appreciate any help! thanks James

 

[mohadin]

Hi
I Believe you need COUNTIFS
some thing like

=COUNTIFS($A$2:$A$16,$A2,$C$2:$C$16,B$1)

 

[Fluff]

Hi & welcome to MrExcel.
Are the dates in col E & the headers on the formula sheet actual dates or just text?