Excel does not have 99999 rows :-). Try:
=SUMPRODUCT(--('749 Open-Pending Inventory'!A2:A9999=1),--('749
"Murph" schrieb im Newsbeitrag
I've tried your suggestion and it seems to be working. I'm just
across a couple of snags. All my data in on sheet 1. I want my
to occur on sheet 2. I can get your formula to work on sheet 1,
data is stored, but when I try in on sheet 2, where it references the
sheet 1, I keep getting an error. This is the formula I am using.
see a problem with it?
=SUMPRODUCT(--(('749 Open-Pending Inventory'!A2:A99999)=1),--(('749
If there is an issue, how do I correct it?
Second question I have is regarding how to excluded certain values
count. For example, using the above calculation, I also want to
rows that have a value in Column "B" of, "small", or "medium". I
quite understand your second formula. How would this work?
"Frank Kabel" wrote:
I'm having trouble figuring out a way to count specific rows in a
have, using multiple variables. For example. I have column A,
B, and C. In
column "A" are number values from 1-10. In Column "B" are
peoples names, and
in Column "C" are other text values. I want to figure out a way
to count all
the rows that have the numbers 1-3 in column "A", the same name
"B", and the same text value in column "C". For example all the
have a value between 1 and 7 in column A, value of "Jones" in
Column B, and a
value of "Open" in column C. In additions to that I also need to
with a formula that does what I described above, but in addition,
and rows that have a specific value in Column "D". I've tried
variations of the COUNT, DCOUNT, SUM, and DSUM functions but have
luck. Any help would be appreciated.