SUMIFS

Micah Turner

I am using a SUMIFS (formula is posted below) formula to compile multiple billing amounts for one job into a single billing amount for the month. However, when I get to a blank line it gives me #INVALID DATA TYPE error. Please see attachments...

Screenshot 2022-09-01 131800.jpg

=SUMIFS({Billing Labor Billed}, {Billing Job #}, [Job #]@row, {Billing Date}, MONTH(@cell) = 1)

KT_H

Because your formula is referencing the Job # on each row, it will show an error when processing on a blank line (or any line where job # is blank). To remove the error use the following formula that is preceded with an IFERROR to clear the predicted issue.

=IFERROR(SUMIFS({Billing Labor Billed}, {Billing Job #}, [Job #]@row, {Billing Date}, MONTH(@cell) = 1), "")

KT_H

Because your formula is referencing the Job # on each row, it will show an error when processing on a blank line (or any line where job # is blank). To remove the error use the following formula that is preceded with an IFERROR to clear the predicted issue.

=IFERROR(SUMIFS({Billing Labor Billed}, {Billing Job #}, [Job #]@row, {Billing Date}, MONTH(@cell) = 1), "")

Micah Turner

That did it. Thank you so much! Sometimes that tunnel vision kills me.