Sumifs formula help please

Tbech · 01/21/21

Trying to determine # of total hours if a specific program is listed. Seems simple but keep getting errors. Attempts below. Any thoughts?

=SUMIFS({Team Range 9}, >0, ({Team Range 8}, FIND("Program", @cell) =true))

=SUMIFS({Team Range 9}, >0, {Team Range 8}, [\[Formula descriptor 2\]]@row)

Paul Newcome · 01/21/21

Try something like this...

=SUMIFS({Hours Column}, {Program Column}, "Program")

Tbech · 01/21/21

Perfect! Thanks!!

Paul Newcome · 01/21/21

Try something like this...

=SUMIFS({Hours Column}, {Program Column}, "Program")

Tbech · 01/21/21

Perfect! Thanks!!

Paul Newcome · 01/21/21

Happy to help. 👍️

Tbech · 01/21/21

Hey Paul, what if "program" is blank.

Paul Newcome · 01/21/21

On the source sheet or the sheet holding the formula?

Best Answers