• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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