I'm using Excel 2010 and I need a formula which can take criteria from 2 different columns, SUM the result of all matching rows:
The columns are Area Manager and Project Type and if both criteri amatch I'd like to SUM the results from a third column on all matching rows.
e.g =SUMIF(F:F,"Adam Jones",H:H ) and =SUMIF(G:G,"Special Projects",H:H ) but all in one cell?
Thanks for any help
Aucun commentaire:
Enregistrer un commentaire