I want to write a sheet summary formula that counts how many rows where the MoSCow column contains M, have attachments.
The syntax I am using is COUNTIFS( range1, criterion1, [ range2,criterion2]).
I have used this formula many times
Getting the column criteria (range 1, criterion 1)specified is straight forward.
But I cannot figure out how to add a range using the "Attachments" column. If I click the column in a row, the window opens. I can hand-type it in BUT what criterion do I use to show an attachment exists? 1 for exists and 0 for does not exist?
=COUNTIFS(MoSCoW@row,"M",[Attachments@row, 1]) gives me "unparseable"
Any hints? Thanks!
Carroll