• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

EXCEL FORMULA TOTALING COLUMN BASED ON TWO CRITERIA

I need an EXCEL formula that will total Column "E" minutes if it meets the station requirements in this case "LAS" and count the minutes Column "E" if they are greater than .30 minutes.    This  is what I have that is not working.

=SUMIF(C4:C164,"LAS",E4:E164,">30")


Column "C" is the station    "LAS"     Column "E" is minutes
0
BOEING39
Asked:
BOEING39
  • 3
1 Solution
 
krishnakrkcCommented:
Hi

If you want to COUNT, use COUNTIFS.

=COUNTIFS(C4:C164,"LAS",E4:E164,">30")

If you are on pre Excel 2007 version, try

=SUMPRODUCT(--(C4:C164="LAS"),--(E4:E164>30))

Kris
0
 
Saqib Husain, SyedEngineerCommented:
=SUMPRODUCT((C4:C164="LAS")*(E4:E164>30)*(E4:E164))
0
 
BOEING39Author Commented:
That did it, thx Kris
0
 
Saqib Husain, SyedEngineerCommented:
For 2007 or later

=SUMPRODUCT((C4:C164="LAS")*(E4:E164>30)*(E4:E164))
0
 
Saqib Husain, SyedEngineerCommented:
I am sorry but either the question is incorrectly written or the answer accepted is not correct. The question asks for

...formula that will total Column "E" minutes...
whereas the accepted answer "Counts" the column E data.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now