Count If Month is Current Month

[ecomp]

Here is the Issue I have 3 Pie Charts, they are populated from a spreadsheet that has a Status page (pie charts are located there), and the status page is updated from 3 additional sheets from the spreadsheet. I need the pie charts to only update with the current month data only, the sums of each sheet is set up by Fiscal year. Oct-Sep rows B1 thru M1, and data is set tasks complete, B2 thru M2, Total Tasks B3 thru M3 and Tasks requiring attention B4 thru M4. How do I write to formula in my Status Page to only count Tasks in Current Month. For example do I write countif(B2:M2=Today())

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep
2	Overall Total Complete	38	35	34	0	0	0	0	0	0	1	0	18
3	Overall Total Tasks	43	41	43	37	38	39	39	38	38	38	37	42
4	Total Tasks REQ ATT.	5	6	9	37	38	39	39	38	38	37	37	24

<colgroup><col width="64" style="width: 48pt;"> <col width="193" style="width: 145pt; mso-width-source: userset; mso-width-alt: 7058;"> <col width="64" style="width: 48pt;" span="12"> <tbody> </tbody>

 

[oldbrewer]

if say current month is in Z1

something like =offset($a$1,1,match(Z1,$b$1:$m$1,0)

so if current month is Dec it would return 34
change the 1 to 2 and it returns 43

 

[Hanchamad]

Oldbrewer,
I'm facing the same issues as ecomp. When I tried your formula it did not work but my thinking is that I don't understand the logic. Can you please tell me in the example formula you have is Z1 a blank cell? Or what is the value in Z1 supposed to be? Please advise.

Thank you,
CAM

 

[Hanchamad]

What I am asking is Z1 in this example the same as D2? And if so, why wouldn't you use (D2,$b$1:$m$1,0)?

 

[AliGW]

Z1 is meant to contain the current month.

 

[Hanchamad]

Thank you. I guess then my next question is what is the value input in cell Z1? What does that look like? Thank you!