#1
|
|||
|
|||
Help basic excel!!
Hello, i would like to know how to create a conditional for this SUMIF.
i want to include a the month into the condionatiol. I would like to know how to sum only the hours for X on Feb and March. I would like to know how to sum only the hours for B on Feb and March. i reach till here below: =SUMIF(M3:M27,AM4,N3:N27)+SUMIF(O3:O27,AM4,P3:P27) thank you in advanced. |
#2
|
|||
|
|||
An example
|
#3
|
||||
|
||||
Posting a sample sheet would have helped. Pictures are useless
Also, do NOT align text manually. Numbers are right aligned and text left aligned, which helps greatly when building sheets. In your picture everything is centered...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't OPEN EXCEL Spreadsheet in Visual Basic | brianemcnamee | Other Software | 0 | 08-14-2018 11:37 AM |
Accessing Visual Basic on my 2010 copy of Excel | justphilip | Excel Programming | 2 | 02-15-2016 08:54 AM |
Replacing cells in Excel-Very basic with minor conditions | mag | Excel | 1 | 10-26-2012 10:59 AM |
Excel 2010 Visual Basic design/coding | charlesmac | Excel Programming | 2 | 08-10-2012 01:13 AM |
Basic operation of Excel not working! | praveen_p | Excel | 2 | 04-23-2009 10:21 AM |