Microsoft Office Forums - View Single Post - hi I need total job in month In yellow

Thread: hi I need total job in month In yellow

View Single Post

Old

05-06-2016, 02:49 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Try in B2 copied to the right

=SUMPRODUCT(--(MONTH($B$4:$B$23)=COLUMN(A1)))

Reply With Quote