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())


[TABLE="width: 769"]
<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>[TR]
[TD="class: xl75, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl80, width: 193, bgcolor: transparent"]A[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl75, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]E[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]F[/TD]
[TD="class: xl75, width: 64, bgcolor: transparent"]G[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]H[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]I[/TD]
[TD="class: xl75, width: 64, bgcolor: transparent"]J[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]K[/TD]
[TD="class: xl76, width: 64, bgcolor: transparent"]L[/TD]
[TD="class: xl77, width: 64, bgcolor: transparent"]M[/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"]1[/TD]
[TD="class: xl81, bgcolor: white"] [/TD]
[TD="class: xl70, bgcolor: white"]Oct[/TD]
[TD="class: xl71, bgcolor: white"]Nov[/TD]
[TD="class: xl71, bgcolor: white"]Dec[/TD]
[TD="class: xl71, bgcolor: white"]Jan[/TD]
[TD="class: xl71, bgcolor: white"]Feb[/TD]
[TD="class: xl71, bgcolor: white"]Mar[/TD]
[TD="class: xl71, bgcolor: white"]Apr[/TD]
[TD="class: xl71, bgcolor: white"]May[/TD]
[TD="class: xl71, bgcolor: white"]Jun[/TD]
[TD="class: xl71, bgcolor: white"]Jul[/TD]
[TD="class: xl71, bgcolor: white"]Aug[/TD]
[TD="class: xl72, bgcolor: white"]Sep[/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"]2[/TD]
[TD="class: xl82, bgcolor: white"]Overall Total Complete[/TD]
[TD="class: xl73, bgcolor: white"]38[/TD]
[TD="class: xl66, bgcolor: white"]35[/TD]
[TD="class: xl66, bgcolor: white"]34[/TD]
[TD="class: xl66, bgcolor: white"]0[/TD]
[TD="class: xl66, bgcolor: white"]0[/TD]
[TD="class: xl66, bgcolor: white"]0[/TD]
[TD="class: xl66, bgcolor: white"]0[/TD]
[TD="class: xl66, bgcolor: white"]0[/TD]
[TD="class: xl66, bgcolor: white"]0[/TD]
[TD="class: xl66, bgcolor: white"]1[/TD]
[TD="class: xl66, bgcolor: white"]0[/TD]
[TD="class: xl67, bgcolor: white"]18[/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"]3[/TD]
[TD="class: xl82, bgcolor: white"]Overall Total Tasks [/TD]
[TD="class: xl73, bgcolor: white"]43[/TD]
[TD="class: xl66, bgcolor: white"]41[/TD]
[TD="class: xl66, bgcolor: white"]43[/TD]
[TD="class: xl66, bgcolor: white"]37[/TD]
[TD="class: xl66, bgcolor: white"]38[/TD]
[TD="class: xl66, bgcolor: white"]39[/TD]
[TD="class: xl66, bgcolor: white"]39[/TD]
[TD="class: xl66, bgcolor: white"]38[/TD]
[TD="class: xl66, bgcolor: white"]38[/TD]
[TD="class: xl66, bgcolor: white"]38[/TD]
[TD="class: xl66, bgcolor: white"]37[/TD]
[TD="class: xl67, bgcolor: white"]42[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: transparent"]4[/TD]
[TD="class: xl83, bgcolor: white"] Total Tasks REQ ATT.[/TD]
[TD="class: xl74, bgcolor: white"]5[/TD]
[TD="class: xl68, bgcolor: white"]6[/TD]
[TD="class: xl68, bgcolor: white"]9[/TD]
[TD="class: xl68, bgcolor: white"]37[/TD]
[TD="class: xl68, bgcolor: white"]38[/TD]
[TD="class: xl68, bgcolor: white"]39[/TD]
[TD="class: xl68, bgcolor: white"]39[/TD]
[TD="class: xl68, bgcolor: white"]38[/TD]
[TD="class: xl68, bgcolor: white"]38[/TD]
[TD="class: xl68, bgcolor: white"]37[/TD]
[TD="class: xl68, bgcolor: white"]37[/TD]
[TD="class: xl69, bgcolor: white"]24[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!