Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-02-2022, 07:02 PM
Pikachu Pikachu is offline Help basic excel!! Windows 11 Help basic excel!! Office 2019
Novice
Help basic excel!!
 
Join Date: Mar 2022
Posts: 1
Pikachu is on a distinguished road
Default 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.
Attached Images
File Type: jpg Screenshot 2022-03-02 225952.jpg (57.7 KB, 17 views)
Reply With Quote
  #2  
Old 03-03-2022, 02:07 AM
ArviLaanemets ArviLaanemets is offline Help basic excel!! Windows 8 Help basic excel!! Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

An example
Attached Files
File Type: xlsx SumifsExample.xlsx (10.3 KB, 4 views)
Reply With Quote
  #3  
Old 03-03-2022, 07:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help basic excel!! Windows 7 64bit Help basic excel!! Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

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
Help basic excel!! Accessing Visual Basic on my 2010 copy of Excel justphilip Excel Programming 2 02-15-2016 08:54 AM
Help basic excel!! 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
Help basic excel!! Basic operation of Excel not working! praveen_p Excel 2 04-23-2009 10:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft