samedi 18 janvier 2020

SUMIF Array Formula with "GREATER THAN"

I know this may work:

=ArrayFormula(sum(SUMIF(D2:D9&F2:F9,J2:J3&H2,E2:E9)))

But I don't know how to find any solution for this

=ArrayFormula(sum(SUMIF(D2:D9&F2:F9,J2:J3&(">"&H2),E2:E9)))

Basically, I want to SUMIF with multiple criterias with array formula. But I can't find a way with criteria that greater than something

this is the sample case: https://docs.google.com/spreadsheets/d/1lyPSurAudZOAn2HHGPaKcgmwso46f3K4dVYA6dwlDjM/edit#gid=0

the case is about summing the quantity given from each activity, given some range of date.

  1. array formula is needed since I want the list of activity to be flexibly added, without me having to edit the formula.
  2. as far as I know, sumifs cant be used because sumifs doesn't work with array formula

Aucun commentaire:

Enregistrer un commentaire