COUNTIF or SUMPRODUCT
 

I have to count the number of approved loans, 1 column will have P/L or H/L,
and the next column will have the approved amount. But not all are approved.
A B
P/L 2000
P/L 0
H/L 158000
P/L 1000
H/L 0
I need a function that will count all the P/L that are greater than zero and
also the number of H/L that are greater than zero. Can anyone help??

COUNTIF or SUMPRODUCT
 

An example for "P/L":
=SUMPRODUCT((A1:A5="P/L")*(B1:B50))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Jimmy1982" wrote:
I have to count the number of approved loans, 1 column will have P/L or H/L,
and the next column will have the approved amount. But not all are approved.
A B
P/L 2000
P/L 0
H/L 158000
P/L 1000
H/L 0
I need a function that will count all the P/L that are greater than zero and
also the number of H/L that are greater than zero. Can anyone help??