How do I count something that has two fields that must be true
I am working to count items in a spreed sheet that has several fields on it.
I want to count how many items have an item number of "4016" and a price of "100". Both fields must equal true for it to count them. Thank you, Charles |
=SUMPRODUCT(--(B2:B100=4016),--(C2:C100=100))
-- HTH RP (remove nothere from the email address if mailing direct) "Charles" wrote in message ... I am working to count items in a spreed sheet that has several fields on it. I want to count how many items have an item number of "4016" and a price of "100". Both fields must equal true for it to count them. Thank you, Charles |
All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com