LinkBack URL
About LinkBacks
Try this...
Use cells to hold the date criteria.
A1 = start date
B1 = end date
=SUMIFS(BAR!$K$1:$K$9022,BAR!$A$1:$A$9022,V$2,BAR!$AK$1:$AK$9022,$A58,BAR!$G$1:$G$9022,">="&A1,BAR!$H$1:$H$9022,"<="&B1)
Try this...
Use cells to hold the date criteria.
A1 = start date
B1 = end date
=SUMIFS(BAR!$K$1:$K$9022,BAR!$A$1:$A$9022,V$2,BAR!$AK$1:$AK$9022,$A58,BAR!$G$1:$G$9022,">="&A1,BAR!$H$1:$H$9022,"<="&B1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks