You're welcome. Thanks for the feedback!

Biff

"Rocket" wrote in message
...


"Biff" wrote:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","promote
to
CEO"})

<g

Biff

"Biff" wrote in message
...
Hi!

If I understand, try this:

=LOOKUP(SUM('1st Q:4th Q'!F6),{0,3,4,5},{"","verbal","written","time
off"})

Biff

"Rocket" wrote in message
...
Hello,
I'm working on a attendance and vacation worksheet. The fist tab is a
summary of the other 4 tabs. This very similar to Micosofts tracking
templete1.I'm having trouble with summing multiple worksheet with a if
then
statement. Here is what I have so far,
=SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the
value
is greater than 2 "verbal warning, grater than 3 "written waning",
greater
than 4 "days suspension". I thought about putting the =sum statement
in
VB,
and use the cell for the =if statement, but I'm not to sure how.
Thank you for you time!




This work great! Thanks again for the quick responce.