If statement using multiple conditions

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

Guest

If I have M or F in cell D2:D196, Actual hours worked in cell O2:O196, Full
time equivalent hours in cell P2:P196 and a value in cell AE2:AE196 and I
want to sum the values in cells AE2:AE196 if the criteria of F (col D)
working less than the FTE hrs is satisfied can someone please advise me the
best formula to use? Thanks
 
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

If Hours >0, If Volume <= 0,(and vice-versa) then.... 4
SUMIF using value from MOD function 2
Function IF statement 11
sum the values of a range based upon multiple ranges and criteria 1
using a conditional in STDEV function 1
Using multiple IF conditions 3
Entering an If formula using conditional formatting 1
Multiple Variables in Conditional Formatting with Excel 2003 1

Back
Top