Thank you to all
Thank you to all
Last edited by SG56001235; 12-20-2013 at 12:43 PM.
Take a look to COUNTIFS function.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
=countifs($b$3:$b$5000,t3,$i$3:$i$5000,"<"&"0")
You're just beating me to the punch all day.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Here you go.
=COUNTIFS(B:B,T2,I:I,"<0")
COUNTIF looks for multiple criteria. COUNTIF(Range 1, Criteria 1, Range 2, Criteria 2)
So in this formula it will only count if the same row in Range 1 (B:B) meets Criteria 1 (Cell T2) and in the same row of Range 2 (I:I) meets Criteria 2 (<0)
Last edited by vamosj; 12-20-2013 at 11:51 AM.
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
everyone ese beat me to it ,i was just going to make some observation about posting images as well
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
=COUNTIF(E:E,"<"&0) in column U
@ azumi i know pictures make things hard but that is so far off the op's requirement are you sure you responded to the correct post?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks