Hello,

This is my first posting to this forum, and I haven't been able to
search using the right criteria (not even sure what I would search
under) to find what I need so I thought I would post a thread with the
question.

I have an access query that gives me the results in a spreadsheet
layout, with 2 worksheets on it.

I need to create a forumla that will look at the data on the 2nd sheet
and compare the values in 2 particular columns with the value in one
cell on the 1st sheet and populate a different cell on the 1st sheet
with a count of entries from the 2nd sheet.


If Sheet B, Column 1 (2:897 data range) AND Sheet B Column 2 (also
2:897 data range) = Sheet A Cell D, count those entries on Sheet B
Column 2 (2:897 data range) equal to the data in Sheet A Cell E, and
populate Sheet A Cell F with the number.

Is such a forumla possible?

Please help me ASAP, as I'm ok with the simpler formulas, but these
tougher ones are beyond my ability without some help.

I need to know so that I can get my boss off my case by either getting
the formula figured out or by telling him that its not possible.

Thanks for any and all help in advance.

-JT




--
JTKrupa
------------------------------------------------------------------------
JTKrupa's Profile: http://www.excelforum.com/member.php...o&userid=27759
View this thread: http://www.excelforum.com/showthread...hreadid=472703