Thread
:
Formula
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
Posts: n/a
Formula
try this where you don't use the whole column and the ranges are the SAME
size.
=sumproduct((rngA="Approved")*(rngB="insurance")*r ngC)
--
Don Guillett
SalesAid Software
"esmer" wrote in message
...
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?
Reply With Quote