hi I need total job in month In yellow

zEr · #1 05-06-2016, 12:05 PM

hi I want write how many total job in month inside Color yellow, thanks

jeffreybrown · #2 05-06-2016, 02:49 PM

Try in B2 copied to the right

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

zEr · #3 05-06-2016, 03:55 PM

thank you jeffreybrown for the solution!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populate D1 if A4 is yellow	Tuph	Excel	3	05-07-2015 02:25 AM
Red/Yellow/Green as Summary Level	USTSUser	Project	1	08-12-2014 01:05 PM
Remove yellow highlightning in a protected document ?	spookiepower	Word	3	01-30-2014 03:34 PM
Copy Row based on yellow highlighting.	imogul	Excel	2	09-28-2011 04:11 AM
Text Highlighting in Yellow ???	mark4man	Publisher	0	12-15-2005 06:46 PM