you could also use this array formula
entered with ctrl+shift+enter.![]()
SUM(--(TEXT($B$1:$B$5,"mmmm")=$E1))
this would eliminate the helper column
you could also use this array formula
entered with ctrl+shift+enter.![]()
SUM(--(TEXT($B$1:$B$5,"mmmm")=$E1))
this would eliminate the helper column
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks