I'm trying to use the sumifs formula to add a column of amounts using two tests in the same column.
=SUMIFS(F19:F23,H19:H23,"APPROVED", H19:H23, "T&M EXTRA")
The formula works if I use either of the criteria range and criteria test but not if I use both.
Also trying to use a similar formula in column B.
Bookmarks