excel, how do I get sumif with two criterias?
I've got a table with many columns and I want to add the last left column but
using two criterias for two different columns. |
=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"),rng3)
the ranges cannot be whole columns -- HTH RP (remove nothere from the email address if mailing direct) "Mosqui" wrote in message ... I've got a table with many columns and I want to add the last left column but using two criterias for two different columns. |
All times are GMT +1. The time now is 02:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com