Hello Everyone,
I'm not a pro (by far) in Excel, but have been able to learn a lot online. Right now I am stuck on an excel worksheet that I used to count how many times words are being used in a demographic data collection. I'm using COUNTIF for one set of criteria and COUNTIFS when there are multiples; all of this is entered in each tab/sheet for each particular month (JAN, FEB, MAR, etc.). I want to have a "year total" tab/sheet at the beginning that organizes all the work. Here is my question:
How can I copy the first row of formulas across the remaining months? Here is what the formula looks like and what I would like the drag/copy to look like:
B3=COUNTIF(JAN!$D$2:$D$201,"MALE") C3=COUNTIF(JAN!$D$2:$D$201,"FEMALE") ----->AI3=COUNTIF(JAN!J2:J201,"HOMELESS")
B4=COUNTIF(FEB!$D$2:$D$201,"MALE") C4=COUNTIF(FEB!$D$2:$D$201,"FEMALE")
This goes across to BL3 and I thought I could select the entire row and drag/copy the formula to from JAN to DEC.
Is this something that I can on Excel? Any feedback would be great.
Bookmarks