I have a spreadsheet I need to create a summary page of data on the
spreadsheet. Here is the question "If columnA eq approved and columnB eq
insurance then sum colunmC?
I have a spreadsheet I need to create a summary page of data on the
spreadsheet. Here is the question "If columnA eq approved and columnB eq
insurance then sum colunmC?
try this where you don't use the whole column and the ranges are the SAME
size.
=sumproduct((rngA="Approved")*(rngB="insurance")*rngC)
--
Don Guillett
SalesAid Software
[email protected]
"esmer" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet I need to create a summary page of data on the
> spreadsheet. Here is the question "If columnA eq approved and columnB eq
> insurance then sum colunmC?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks