# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

How can I count the number of rows within a certain date range from a different sheet in a workbook? Similarly, can I sum the numerical values in one column within that date range?
Solved by A. C. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 16/08/2018 - 03:01
Hello!
User 16/08/2018 - 03:01
Hey there
Excelchat Expert 16/08/2018 - 03:01
Welcome to got it pro!
Excelchat Expert 16/08/2018 - 03:01
I saw you have a question regarding countif and sumif functions
User 16/08/2018 - 03:02
Yes!
Excelchat Expert 16/08/2018 - 03:04
Here are some examples
User 16/08/2018 - 03:04
So if I wanted to count everything within that date range, but have it displayed on a separate sheet, what would the formula look like?
User 16/08/2018 - 03:05
I have a vague idea, but can't seem to get it right
Excelchat Expert 16/08/2018 - 03:05
That will be the same
Excelchat Expert 16/08/2018 - 03:05
:-)
User 16/08/2018 - 03:05
Don't I need to specify which sheet it's coming from?
Excelchat Expert 16/08/2018 - 03:06
YEs
Excelchat Expert 16/08/2018 - 03:06
When you click another file, excel will automatically recognizet the new file name
Excelchat Expert 16/08/2018 - 03:07
Here are the examples for sumifs countif
Excelchat Expert 16/08/2018 - 03:08
Please feel free to let me know if you have any questions
Excelchat Expert 16/08/2018 - 03:09
Otherwise, please feel free to end the session as you needed :-)
Excelchat Expert 16/08/2018 - 03:09
Also, please feel free to provide us some positive feedback at the end of the session!
User 16/08/2018 - 03:10
Excelchat Expert 16/08/2018 - 03:10
Sure.
Excelchat Expert 16/08/2018 - 03:10
User 16/08/2018 - 03:11
If I wanted the total to be displayed on Sheet 2, but the data was on Sheet 1, how do I specify in the formula where the data is coming from?
Excelchat Expert 16/08/2018 - 03:11
Sure
Excelchat Expert 16/08/2018 - 03:12
AS you can see once you click the tab you need to sum the number then excel wil recognize it
User 16/08/2018 - 03:13
OK cool! One last question. If, instead of counting within a range (like A1:A10), how could I count within a whole column? Would I simply remove the :A10?
Excelchat Expert 16/08/2018 - 03:13
A:A
User 16/08/2018 - 03:14
Awesome
User 16/08/2018 - 03:14
Thank you very much!
Excelchat Expert 16/08/2018 - 03:14
No problem!
User 16/08/2018 - 03:14
I'll give it a try
Excelchat Expert 16/08/2018 - 03:14
Hope you enjoy this session
User 16/08/2018 - 03:14
Thanks
Excelchat Expert 16/08/2018 - 03:14
And wish you have a awesome night!
User 16/08/2018 - 03:14
Likewise :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.