•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel tally table using formulas
Hi All, quite new here and still learning Excel.
Im trying to set up a Table to keep track of all my university assessments and tests due this year.
Im trying to create a tally table that will count all the tests/assignments that are submitted early, the ones that are submitted on time, and the ones submitted late.
I want the the tally to be determined if Column K says "SUBMITTED", and if the date in Column I is before the date in Column G.
Ive tried several different fomulas but it keeps returning an array, not tallying correctly or counting blank spaces.
Any help will be greatly appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#machine learning in spreadsheet applications
#real-time data collaboration
#real-time collaboration