Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

Changing a cool formula that gets me totals to counts

I have the following formula
=IFNA(C2*VLOOKUP(E2,DontDelete!$A$2:$N$50,7,FALSE),0)
it works well to get me a sum of values in the matching criteria but I am looking for the matching count of rows it used.
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Or simply try this which will return the matching row...

=IFERROR(MATCH(E2,DontDelete!A:A,0),"")

Open in new window

Avatar of Matt Pinkston
Matt Pinkston

ASKER

excellent help