Thread
:
Total up values for one month
View Single Post
#
3
Posted to microsoft.public.excel.programming
Gary''s Student
external usenet poster
Posts: 11,058
Total up values for one month
In G1 enter:
=SUMPRODUCT(--(F$1:F$11),--(MONTH(E$1:E$11)=ROW()))
and copy down
--
Gary''s Student - gsnu200735
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student