Hello! I am having some trouble writing a formula.
I need to do the sum of Column A, if Column B = "x", but only if Column C is NOT blank.
I'm using a calculations sheet to pull data from a larger sheet and the current calculation I have is
=SUMIFS({Column B}, [Primary Column]@row, {Column A})
My [Primary Column]@row = "x" which is used on my calculations sheet. Im having trouble incorporating Column C NOT blank.
Thanks in advance!
