Trying to add on to my countifs formula on sheet2
I have all raw data on the Main tab and would like to manipulate the data from the date range that I select on the sheet 2 tab (cell k2 and k3)
Trying to add on to my countifs formula on sheet2
I have all raw data on the Main tab and would like to manipulate the data from the date range that I select on the sheet 2 tab (cell k2 and k3)
=COUNTIFS(Main!$K2:$K312,Sheet2!B$1,Main!$B2:$B312,Sheet2!$A2,Main!$A$2:$A$312,">="&Sheet2!$K$2,Main!$A$2:$A$312,"<"&Sheet2!$K$3)
Copying this down and over will result in zeroes, because the filter is set for 2013, and raw data is 2014.
Last edited by daffodil11; 02-28-2014 at 06:48 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hi esaban,
I think a Pivot Table may be a better tool for this problem. See what they can do on the attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks