Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top