Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-16-2006, 06:55 AM
pumpkin head pumpkin head is offline
Novice
Multiple criteria in SUMIF?
 
Join Date: Feb 2006
Posts: 1
pumpkin head
Default Multiple criteria in SUMIF?


Hi, I'm after some help regarding SUMIF.

Basically I want to add up all of the numbers in column O that have a 100 in column A, and a 6 in column D.

I can do this separately like so:

SUMIF(A:A,100,O:O)

and

SUMIF(D: D,6,O:O)

but that doesn't help me, because I want to filter out any row which doesn't have a 100 in A and a 6 in D.

Any help would be appreciated.

PH.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Folders in Outlook Cabbage1031 Outlook 0 05-23-2007 10:56 AM
Help with consolidating multiple records into one wbiggs2 Excel 0 11-30-2006 01:02 PM
How to count cells containing data and meet certain criteria AdamNT Excel 1 08-11-2006 11:51 PM
Multiple criteria in SUMIF? Filtering past or future events in DRW query criteria jvieille Misc 1 02-11-2006 06:26 AM
import multiple categories stormin.norm Outlook 0 01-30-2006 01:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 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