KSL

You need to check the syntax of sumproduct. Try

=SUMPRODUCT(--('sheeta'!B2:B127=$G$9),--('sheetb'!A2-A127=F10))

Good luck.

Ken


On Jul 16, 5:08 pm, Leonhardtk
wrote:
I assume SUMPRODUCT is what I want.

In sheeta, I have to columns of interest:
A2:A127 is text data created by IF statements. An example of A2 would be
"0-30", meaning to say "0-30 days". B2:B127 is a list of last names, also
created by a worksheet function.

In sheet b, I'm creating tables based on these, and other data elelments.

In one table, I do a =COUNTIF('sheeta'!A2-A127,"=" &'sheetb'!F2) sheetb F2
is a text colum that says "0-30" THis works fine.

I want to do the same exact function, but check column B2:B127 in sheet a
for a name. SUMPRODUCT I tried was:

In sheetb, Cell G10 I have the following:
=SUMPRODUCT('sheeta'!B2:B127=$G$9)*SUMPRODUCT('she etb'!A2-A127=F10)
(G9 is a name, such as Smith, which occurs on various lines in sheeta B2:B127(
F10 is just like F2 above, it has the text, "0-30".

What I want is a total number for each row that has both "Smith" in the B
column and "0-30" in the A-column.

(Buy the way I have a PIVOT table that does this just fine, but I need
something that is dynamically upadated (when the data changes).

Thanks!

KSL.