Daily Archives: December 13, 2023

I want to fill in these 2 cells with a formula. Normally Id filter country for Canada and run a subtotal below. with something like this =SUBTOTAL(9,J4:J8) How can I combine a vlookup into my subtotal with subtotalling filtered countries? expected output – thanks.

At the moment I can access a MySQL database by SSHing in terminal. This prompts me for a passphrase for a key ssh test-db01.somedomain.com Enter passphrase for key '/Users/yourname/.ssh/path/to/key': which I enter. At this point I am in the remote host and can simply type mysql > SELECT * FROM […]