if you have 1 in a cell, say Y1
=SUMPRODUCT(--(A1:A100="WalMart"),--(MONTH(C1:C100)=Y1),F1:F100)
or if you have the text January in Y1, then
=SUMPRODUCT(--(A1:A100="WalMart"),--(TEXT(C1:C100,"mmmm")=Y1),F1:F100)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"tjr" wrote in message
...
I am trying to create a function in a checkbook register type workbook
that
will do the following:
if name in column a = x and date in column c = y then add the numbers in
column f that pertain to both x and y.
I am trying to break down monthly spending at specific places - as in -
walmart purchases in january.
Is this possible?
Thank you for any assistance
|