Hi,
I need to:
Count A1, if D2 equals E2, and A2 equals 101
PIC.jpg
'=COUNTIFS(A1,"D1=D2",A1,"101")' does not work.
Could someone help me please?
Thank you!
Kevin
Hi,
I need to:
Count A1, if D2 equals E2, and A2 equals 101
PIC.jpg
'=COUNTIFS(A1,"D1=D2",A1,"101")' does not work.
Could someone help me please?
Thank you!
Kevin
Are you asking to count all the values where column A = 101 and Quantity on Hand = Quantity Committed?
=SUMPRODUCT(--($A$2:$A$100= 101), --($D$2:$D$100 = $E$2:$E$100))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes Sir Mr. ChemistB!
And your formula works great! All set.
Thank you!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks