Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2022, 05:01 AM
tomohawk tomohawk is offline Issue With SUMIF and Range Windows 10 Issue With SUMIF and Range Office 2019
Novice
Issue With SUMIF and Range
 
Join Date: Sep 2020
Posts: 23
tomohawk is on a distinguished road
Default Issue With SUMIF and Range

I have a spreadsheet (attached) and I want to use SUMIF.

However, I want to use a range of cells (multiple cells/rows) to get the sum.

It appears that only the first column is used to get the sum.



What are my options?

Tommy
Attached Files
File Type: xlsx SUMIF Issue.xlsx (11.3 KB, 7 views)
Reply With Quote
  #2  
Old 11-08-2022, 06:24 AM
Marcia's Avatar
Marcia Marcia is offline Issue With SUMIF and Range Windows 11 Issue With SUMIF and Range Office 2021
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 506
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Use SUMIFS for multiple criteria/range.
Reply With Quote
  #3  
Old 11-08-2022, 10:13 AM
fjns fjns is offline Issue With SUMIF and Range Windows 10 Issue With SUMIF and Range Office 2019
Novice
 
Join Date: Sep 2022
Location: Hungary, Szeged
Posts: 16
fjns is on a distinguished road
Default

Hi, see the next links...

SUMIF function

"Sum_range should be the same size and shape as range. If it isn't, performance may suffer, and the formula will sum a range of cells that starts with the first cell in sum_range but has the same dimensions as range."

SUMIFS function

"The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument."
Attached Files
File Type: xlsx SUMIFIssueRepair.xlsx (11.6 KB, 4 views)
Reply With Quote
  #4  
Old 11-11-2022, 03:42 AM
Debaser's Avatar
Debaser Debaser is offline Issue With SUMIF and Range Windows 10 Issue With SUMIF and Range Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 211
Debaser will become famous soon enough
Default

You can use:

=SUMPRODUCT(($A$2:$A$20=D22)*$D$2:$F$20)

in D23 and copy across.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue With SUMIF and Range Using SUMIF to pull text from another cell as range kong1802 Excel 2 02-07-2017 11:04 AM
Issue With SUMIF and Range Sumif with various conditions in the same range Haha88 Excel 8 12-28-2016 09:15 PM
Issue With SUMIF and Range Sumif based on date range Skumby Excel 2 07-28-2016 10:39 PM
Issue With SUMIF and Range MS Project Date Range Issue appelguy@gmail.com Project 2 10-31-2015 11:52 AM
Issue With SUMIF and Range Sumif with multiple sum range Haha88 Excel 6 10-29-2015 03:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:24 PM.


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