Use of SUMIF Function to get total from different column

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440
Howdy,

Here is what I am trying to do:

Have multiple columns and multiple rows of data in spreadsheet.
I want to first select ONLY those records with a specific value (lets say value is YES)from column D (Cells contain either Yes or No). I then (ONLY FOR THOSE selected records) want to get the total from column X (Hours worked) for the records selected from Column D.

ANy thoughts on how to do this?
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,048
Office Version
  1. 365
Platform
  1. Windows
Something like this perhaps.

=SUMIF(D1:D10,"Yes",X1:X10)
 

ACommandLineKindaGuy

Active Member
Joined
May 11, 2002
Messages
304
If I understnd you correctly, you're already there--you know you need to use SUMIF in an empty cell on the same sheet as the data as follows:

=SUMIF(D:D,"Yes",X:X)
 

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440
Got it

Thanks for the solution boy was that an easy one. Have another issue which I will post next
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,649
Members
412,335
Latest member
cinciri99
Top