LinkBack URL
About LinkBacksI need to count two columns in the same worksheet. Example count if columnA
eq approved and columnB eq insurance then count?
I need to count two columns in the same worksheet. Example count if columnA
eq approved and columnB eq insurance then count?
=sumproduct(-(A1:A10000="Approved"),-(B1:B10000="Insurance"))
"esmer" wrote:
> I need to count two columns in the same worksheet. Example count if columnA
> eq approved and columnB eq insurance then count?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks