Formula Help

Applegate_Sydney

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!

Nic Larsen

Try:

=SUMIFS({Column A}, {Column B}, "X", {Column C}, NOT(ISBLANK(@cell)