#1
|
|||
|
|||
hi I need total job in month In yellow
hi I want write how many total job in month inside Color yellow, thanks
|
#2
|
|||
|
|||
Try in B2 copied to the right
=SUMPRODUCT(--(MONTH($B$4:$B$23)=COLUMN(A1))) |
#3
|
|||
|
|||
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 |