• Status: Solved
• Priority: Medium
• Security: Public
• Views: 366

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
• 3
1 Solution

Commented:
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

EngineerCommented:
=SUMPRODUCT((C4:C164="LAS")*(E4:E164>30)*(E4:E164))
0

Author Commented:
That did it, thx Kris
0

EngineerCommented:
For 2007 or later

=SUMPRODUCT((C4:C164="LAS")*(E4:E164>30)*(E4:E164))
0

EngineerCommented:
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.