ExcelBanter - Formula that captures criteria from 2 different columns "Help ME"

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula that captures criteria from 2 different columns "Help ME" (https://www.excelbanter.com/excel-programming/299548-formula-captures-criteria-2-different-columns-help-me.html)

poloxstar

Formula that captures criteria from 2 different columns "Help ME"

I am trying to get a total count based on 2 different information from
columns.

example
Time Code
60 9999
60 9999
50 5696

Countif (Time60, and Code = 9999)

If and could help, it would be so great.
Thank

--
Message posted from http://www.ExcelForum.com

Frank Kabel

Formula that captures criteria from 2 different columns "Help ME"

Hi
try
=SUMPRODUCT(--(A1:A10060),--(B1:B100=9999))

--
Regards
Frank Kabel
Frankfurt, Germany

I am trying to get a total count based on 2 different information
from 2 columns.

example
Time Code
60 9999
60 9999
50 5696

Countif (Time60, and Code = 9999)

If and could help, it would be so great.
Thanks

---
Message posted from http://www.ExcelForum.com/

All times are GMT +1. The time now is 07:51 PM.