SUM IF But..

[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, and if there is data 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. on AE

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

So at the end i need a formula that would do,

SUMIFS first if there is data on AH then do not count it, if there is not do a SUMIFS on AE.



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

Attahed are both sheets

 

[Joe4]

Triplicate:

Count if Sum if question

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

www.mrexcel.com

SumIFS with Count If Help

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

www.mrexcel.com

You have been warned and referred to the rules numerous times in posts and private messages.
Your account has been placed in a Moderation status.
Continued failure to follow the rules and directions of the Moderators will lead to permanent loss of posting privileges.