Morning guys
Attached is a small file in cell K4 is the formula that I have a problem with, just can't get it right.
I basically need the formula to match one criteria and then count another criteria, one is horizontal and then other one vertical
Can somebody pls help
regards
PH
In K4 Cell
Formula:
Please Login or Register to view this content.
Drag it down and right..
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
hi PH. would be good if you can manually key in the answers you hope to see. so 1110 could be in any row? can it be repeated? for the first, try:
=COUNTIF(INDEX($E$4:$I$8,MATCH(1110,$D$4:$D$8,0),),K$3)
for the 2nd, use Sixthsense's method or try:
=SUMPRODUCT(($D$4:$D$8=1110)*($E$4:$I$8=K$3))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Txs Sixthsense
Works perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks