mardi 23 juin 2015

Need a SUMIF formula to use criteria from 2 columns in Excel

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