multiple conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi!

If I understand, try this:

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

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

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

<g>

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

<g>

Biff




This work great! Thanks again for the quick responce.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula or equation 3
Summing over multiple worksheets 1
Help with IF stament (getting result FALSE in some cases) 9
Complex conditions using SUMIF 8
Sumif banding on a condition 5
Conditional Formatting 2
Complicated IF statement - desperately need some help 4
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7

Back
Top