Help with COUNTIFS

[Harriman2022]

Hi,

I am trying to COUNTIFS function with a few different conditions:

=countifs('Key Property Info'!A:A,"media",'Key Property Info'!H:H,{"contract sent","apps sent"})

I would like excel to return the value of the the contract sent and apps sent figures, where they are applicable to 'media'.

Everything is working other than the fact that the result only returns "contract sent" figure and excludes "apps sent" - both of these statements are within the same column.

I also have the exact same scenario only for a SUMIFS function.

Thanks,
Alex

 

[Fluff]

Hi & welcome to MrExcel.
If you just want a single value then you need to wrap the formula in SUM

 

[Harriman2022]

Hi thanks very much for responding.

I have tried the below and it is still only returning the value of "contract sent"

=sum(countifs('Key Property Info'!A:A,C6,'Key Property Info'!H:H,{"contract sent","apps sent"}))

Thanks

 

[Fluff]

Are you trying this in Excel 365, or some other version?

 

[Harriman2022]

Realised I was in Google Sheets rather Excel on 365. It has worked now. Thanks very much for helping.

Out of interest will the same thing solve it if I move the doc to Google Sheets?

 

[Fluff]

Nor sure about Sheets, but you may need to use FormulaArray (or something like that)