lundi 8 juillet 2019

If Cell equals value AND another cell is greater then another cell

So right now my formula is

=COUNTIFS(D4,"Ajay", E4,">"&F4)

Which seems to work fine for 1 item but doesn't seem to work as a range?

=COUNTIFS(D4:D50,"Ajay", E4:E50,">"&F4:F50)

Any ideas?

Aucun commentaire:

Enregistrer un commentaire