ssblue
asked on
excel countif and and count
I need to look at several cells and if they are greater than zero do a count and then multiple by another cell.
Something like this:
=COUNTIF(L10:L21>0) --- count the cells L10 thru L21 if they are > 0
and then
(L10:L21)*(L4)) ---- number of cell >0 multiple times L4
Something like this:
=COUNTIF(L10:L21>0) --- count the cells L10 thru L21 if they are > 0
and then
(L10:L21)*(L4)) ---- number of cell >0 multiple times L4
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks bunches!!
Try below:
Open in new window