Excel SUMIFs formulat not working

Question

Hi,

The formula in the screenshot below isn't working. I'm sure someone in the community will quickly see what I'm doing wrong, as I'm a newbie to Excel formulas. Thanks in advance!!

Here's what I want to pull over from the List of Transactions sheet:

• For column N entries of "4200 Subcontractors"
• If there's an "R" in column J
• Sum the 4200 Subcontractors values in column E

Donna

Answer 1

You have the sum_array in the wrong position. It should be first.

SUMIFS('...'!E5:E316,'...'!N5:N316,"4200...",'...'!J5:J316,"R")