G
Guest
a:a has is a range of monthly purchases and c:c is which month purchased. I
would like on a different sheet to calculate only those gas purchases in
january (automatically).
I tried this but did not succeed:
=IF(AND(Transactions!A:A=A:A,Transactions!C:C="gasoline"),SUM(Transactions!G:G),0)
would like on a different sheet to calculate only those gas purchases in
january (automatically).
I tried this but did not succeed:
=IF(AND(Transactions!A:A=A:A,Transactions!C:C="gasoline"),SUM(Transactions!G:G),0)