SUM, SUMPRODUCT or COUNTIF

[jasonjack]

HI,

I am trying to present some data based on the table below.

I'd like to report for APAC (A) region only 1 instance and a single total of Minutes (C) for SUPPLIER (D).

At the moment using SUMIF and COUNTIFS I get 4 instances of the APAC and 144 Minutes.

Region (G4) Formula is: =COUNTIFS(A:A,"APAC",D:D,"ABC1")

Total Minutes (G5) Formula is: =SUMIFS(C:C,A:A,"APAC",D:D,"ABC1")

Any help would be greatly appreciated.

 

[MARK858]

That looks like a Google sheets formula rather than Excel formula.
Are you using Google sheets?

 

[jasonjack]

That looks like a Google sheets formula rather than Excel formula.
Are you using Google sheets?

I am yes.....I am also using Office 365..

 

[Joe4]

I am yes.....I am also using Office 365..

That is important to note. I have moved this thread to the "A General Discussion & Other Applications" forum. Note the description on that forum:

This forum is for discussion about any application & for questions about applications other than Excel or Access.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.

In the future, you will want to post all your "Google Sheets" questions here, and be sure to clearly mention in your post that it is a Google Sheets question, and not an Excel question.
Though they are similar in a lot of ways, they are NOT the same, and there are differences.

 

[jasonjack]

That is important to note. I have moved this thread to the "A General Discussion & Other Applications" forum. Note the description on that forum:

This forum is for discussion about any application & for questions about applications other than Excel or Access.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.

In the future, you will want to post all your "Google Sheets" questions here, and be sure to clearly mention in your post that it is a Google Sheets question, and not an Excel question.
Though they are similar in a lot of ways, they are NOT the same, and there are differences.

Thanks....so can anyone help?