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.

=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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

excellent help

Open in new window