G
Guest
I have a formula that will will search and give me the totals for the month
and text listed in specific cells:
=SUMPRODUCT(--(MONTH(O31:O1001)=MONTH(AV38)),--(ISNUMBER(SEARCH(AT43,S31:S1001))))
Is it possible to modify the month portion of this formula to check for a
number entered, such as 29025? So the formula would look something like
this:
=SUMPRODUCT(--(NUMBER(O31:O1001)=NUMBER(AV38)),--(ISNUMBER(SEARCH(AT43,S31:S1001))))
and text listed in specific cells:
=SUMPRODUCT(--(MONTH(O31:O1001)=MONTH(AV38)),--(ISNUMBER(SEARCH(AT43,S31:S1001))))
Is it possible to modify the month portion of this formula to check for a
number entered, such as 29025? So the formula would look something like
this:
=SUMPRODUCT(--(NUMBER(O31:O1001)=NUMBER(AV38)),--(ISNUMBER(SEARCH(AT43,S31:S1001))))