Hi, I am still a beginner in Excel but need to try get this sorted:
I am needing to get the sum of E3 to E30 (This contains figures in£ format) with the below criteria.
L3 - L30 need to either be equal to E or EC
A3 - A30 needs to be = to Rem Pl
I tired the below but it does not work, any ideas?
=(SUMIFS(E3:E30,L3:L30,{"=EC","=E"},A3:A30,"*Rem Pl*"))
Bookmarks