G
Guest
I have an Excel SS that has a summary page that has several count if / sum if
values. Many of which refer to date ranges. today etc.
Is it possible for me to capture all data in a range of the last calander
month ie. if i all dates in October.
Currently i have the formulas written to count details within the last 31
days however i would like to make this a little more correct.
example :
=SUMPRODUCT((whoC="gn") * (typec="email " ) * (whenb<B1) * ( whenb >B2) )
B1 = Now()
B2 = B1 - 31
Any help very much appreciated
values. Many of which refer to date ranges. today etc.
Is it possible for me to capture all data in a range of the last calander
month ie. if i all dates in October.
Currently i have the formulas written to count details within the last 31
days however i would like to make this a little more correct.
example :
=SUMPRODUCT((whoC="gn") * (typec="email " ) * (whenb<B1) * ( whenb >B2) )
B1 = Now()
B2 = B1 - 31
Any help very much appreciated