Forum Discussion

little2fern's avatar
little2fern
Brass Contributor
Apr 23, 2020
Solved

What formula to use for multiplying countifs result?

Here is my current formula of C6. I need a new formula for C6 and my goal here is to - find out how many time 'AED' in cell B6 appears (in spreadsheet 'query result') within the selected dates of ce...
excel
Formulas and Functions
little2fern's avatar
little2fern
Brass Contributor
Apr 27, 2020

SergeiBaklan 

I tried removing the <> and it works, however the result isn't what I expect to see.

 

 

In your query result spreadsheet, there're two AED results shown in D4 and D9. This means that the sum of AED appearing in between start date 19/10/2019 and end date 20/03/2020 should be (8+3) = 11. 

However this formula shows the result as 3 instead of 11.

 

What formula should I use in this case?

 

 

Thank you,

Fern

 

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 27, 2020

    little2fern 

    If to sum that will be another task, formula for it is

    =SUMIFS(
  'query result'!E:E,
   'query result'!A:A,">="&$B$2,
   'query result'!A:A,"<="&$B$3,
   'query result'!D:D,B6
)

    as here

    • little2fern's avatar
      little2fern
      Brass Contributor
      Apr 27, 2020

      SergeiBaklan 

      Yes! The results are displaying the correct data.

      Thank you so much, Sergei.

Resources