i didnt see pepe's response but that is basicly putting them together
(although you dont need column D ou can just do it with C)
![]()
=SUMPRODUCT((--($A$3:$A$18=$F$3)*--($B$3:$B$18=$F8)*--(TEXT($C$3:$C$18,"mmmm")=H$4)))
i didnt see pepe's response but that is basicly putting them together
(although you dont need column D ou can just do it with C)
![]()
=SUMPRODUCT((--($A$3:$A$18=$F$3)*--($B$3:$B$18=$F8)*--(TEXT($C$3:$C$18,"mmmm")=H$4)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks