SumIFS with Count If Help

[JD_Excels]

Hello,
On the first image on column F, I want to do a SUMIFs like i am showing in the pictures but need to add to it. I want it to do a sumifs/ count if there is not data in Columns AH then do a sumifs on AE, if there then do not do a sumifs. So if there is data in column AH do not do a sumifs, if there is not do a sumifs.

Currennly i am doing
=SUMIFS('Forecast Validation'!$AE:$AE,'Forecast Validation'!$D:$D,Sheet1!$D6)



Basically i dont want to count or sumifs double on my "Pitch data"

Attahed are both sheets

 

[jorismoerings]

Hi,

Assuming you want to SUM the values in column AE if the value in Column AH is unequal to zero or is blank, try this:

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

 

[Fluff]

Duplicate to: Count if Sum if question

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.