sumif two conditions

[Mr2017]

Hi

I'd like to create a sum if which is based on two conditions:

i) if the "zone" in column A is "zone 2" and
ii) if the word "up" is in column F

I've used the formula below, but Excel doesn't like it!

I'm using the sumif formula in a Summary tab and looking at data in the "PData" tab.

Any help would be much appreciated.

'=SUMIFS(PData!A:A,A:A,”Zone 2”,PData!F:F,”UP”)

Thanks in advance.

 

[kvsrinivasamurthy]

If Column D has data to be summed up

=SUMIFS(PData!A:A,PData!A:A,”Zone 2”,PData!F:F,”UP”)

If range if from row 2 to row 45 to avoid time delay

=SUMIFS(PData!A2:A45,PData!A2:A45,”Zone 2”,PData!F2:F45,”UP”)

 

[Mr2017]

Hi

I tried that but it didn't work?

Also, it's column F that I need to sum up data in, not column D.

 

[kvsrinivasamurthy]

Sorry for the mistake.
If Column D has data to be summed up

=SUMIFS(PData!D:D,PData!A:A,”Zone 2”,PData!F:F,”UP”)