1 min readfrom 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: https://imgur.com/a/znxvMmA

submitted by /u/Akhilios
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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