Hi,
I am trying to create an array formula to sum totals if the name match criteria is met as well as being within certain dates.
=SUM(IF(G4:G10,"A26:A45",IF(C4:C10="Name",'F4:F10)))
G=date entered by user
A=My date list
C=Name of product
F=Dollar value (non constant)
Eg. I want to know the total dollars collected in a period of time for a given product. But with the above formaula I only get a zero return! Can anyone help me?!!!
I am trying to create an array formula to sum totals if the name match criteria is met as well as being within certain dates.
=SUM(IF(G4:G10,"A26:A45",IF(C4:C10="Name",'F4:F10)))
G=date entered by user
A=My date list
C=Name of product
F=Dollar value (non constant)
Eg. I want to know the total dollars collected in a period of time for a given product. But with the above formaula I only get a zero return! Can anyone help me?!!!