Count if Sum if question

[JD_Excels]

Hello,
I am trying to do a sumifs on column F which is working fine.
But i only want it to count if Column AH is empty.

I dont want column F, counting if column AH has data ..

 

[Z51]

If you have one criteria, you can just use SUMIF:

=SUMIF(criteria_range, criteria, sum_range)
=SUMIF(AH:AH,"",F:F)

If you have multiple, you can use SUMIFS:

=SUMIFS(sum_range, criteria_range_1, criteria_1, criteria_range_2, criteria_2, etc.)
=SUMIFS(F:F,AH:AH,"",AD:AD,D6)

These are examples, insert your actual ranges you'd like to refer to. The AH:AH,"" bits are checking to see if the cell in that column is blank for the given row(s).

 

[Fluff]

How about

=SUMIFS('Forecast Validation'!$AE:$AE,'Forecast Validation'!$D:$D,$D6,'Forecast Validation'!$AH:$AH,"")

 

[JD_Excels]

How about

=SUMIFS('Forecast Validation'!$AE:$AE,'Forecast Validation'!$D:$D,$D6,'Forecast Validation'!$AH:$AH,"")

did not work

 

[Fluff]

That is not a very helpful answer.
In what way didn't it work?

 

[JD_Excels]

it is blanking out

 

[JD_Excels]

i need the formula to do a sumifs on AE if AH is empty.

 

[Fluff]

What do you mean by

it is blanking out