Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct or countif | Excel Discussion (Misc queries) | |||
Sumproduct and Countif | Excel Discussion (Misc queries) | |||
CountIf or Sumproduct | Excel Discussion (Misc queries) | |||
COUNTIF or SUMPRODUCT | Excel Discussion (Misc queries) | |||
countif, sumproduct | New Users to Excel |