ExcelBanter - I need a formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I need a formula (https://www.excelbanter.com/excel-discussion-misc-queries/121930-i-need-formula.html)

Jenelle1433

I need a formula

I need formula: count C4:C250 if it contains a 2 only if D4:250 contains a
1. Is it Possible??

Max

I need a formula

One way: =SUMPRODUCT((C4:C250=2)*(D4:D250=1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jenelle1433" wrote:
I need formula: count C4:C250 if it contains a 2 only if D4:250 contains a
1. Is it Possible??

Bob Phillips

I need a formula

=SUMPRODUCT(--(C4:C250=2),--(D4:250 =1))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"Jenelle1433" wrote in message
...
I need formula: count C4:C250 if it contains a 2 only if D4:250 contains a
1. Is it Possible??

Rodrigo Ferreira

I need a formula

I think you want something like this:

=SUMPRODUCT(--(C4:C250=2);--(D2:D250=1))

Rodrigo Ferreira

"Jenelle1433" escreveu na mensagem
...
I need formula: count C4:C250 if it contains a 2 only if D4:250 contains a
1. Is it Possible??

All times are GMT +1. The time now is 12:18 PM.