Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2015, 09:05 PM
ErickTru ErickTru is offline Greetings Windows 7 32bit Greetings Office 2007
Novice
Greetings
 
Join Date: Aug 2015
Posts: 1
ErickTru is on a distinguished road
Default Greetings

Good to be part of this forum. I will start with a problem I encountered when using SumIfs. This is the formula to be used:
=Sumif(B:B,F:F,A:A)
A B C D E F
$100.00 300 $100.00 400
$101.00 301 $101.00 401
$102.00 302 $102.00 402
$103.00 303 $103.00 403
$104.00 304 $104.00 404
$105.00 305 $105.00 405
$106.00 306 $106.00 301
$107.00 307 $107.00 305


$108.00 308 $108.00 310
$109.00 309 $109.00 315
$110.00 310 $110.00 320
$111.00 311 $111.00 406
$112.00 312 $112.00 407
$113.00 313 $113.00 408
$114.00 314 $114.00 409
$115.00 315 $115.00 410
$116.00 316 $116.00 411
$117.00 317 $117.00 412
$118.00 318 $118.00 413
$119.00 319 $119.00 414
$120.00 320 $120.00 415
As you can see, I want the grand total of those contained both in B and F. My result in this example should be $551.00 but the formula used does not work. Your feedback is greatly appreciated and thank you in advance fore your time.
Cheers,
ErickTru
Reply With Quote
  #2  
Old 08-19-2015, 01:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Greetings Windows 7 64bit Greetings Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi and welcome please post a sample sheet. Thx
__________________
Using O365 v2503 - 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
  #3  
Old 08-19-2015, 10:34 AM
gebobs gebobs is offline Greetings Windows 7 64bit Greetings Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Not sure how the data jibes. You have four columns of data and your equation references A through F (i.e. six columns).

SUMIF takes the form SUMIF(range, criteria, [sum_range]). I am not sure what happens when you have a range for the criteria.

I'm not exactly sure what you want to do. What do you mean by "I want the grand total of those contained both in B and F". Do you want to sum column A for rows where B equals F? How would you get $551? No values in B equal the corresponding value in F. B are all 3xx and F are all 4xx. If I only sum those A where the last two digits in B and F are the same, I get $615.
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 09:26 AM.


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