prismatick
New Member
- Joined
- May 30, 2015
- Messages
- 4
Hi everyone,
I'm trying to use the COUNTIF function and SUM formulas to add up data on a second sheet and count the frequency of responses. I've had to write in each letter for the columns individually because they don't autopopulate as I drag them down, which is taking too much time to get the project done effectively.
Do you know how I can take the formulas
=COUNTIF(Sheet2!A:A,1) and =SUM(Sheet2!A:A)
and make the A change to B, C, D etc as I drag the formula down the column?
Thank you so much for your help!
I'm trying to use the COUNTIF function and SUM formulas to add up data on a second sheet and count the frequency of responses. I've had to write in each letter for the columns individually because they don't autopopulate as I drag them down, which is taking too much time to get the project done effectively.
Do you know how I can take the formulas
=COUNTIF(Sheet2!A:A,1) and =SUM(Sheet2!A:A)
and make the A change to B, C, D etc as I drag the formula down the column?
Thank you so much for your help!