Sorry, but if that excellent article by Chip hasn't explained it clearly to
you, I don't think I can do better. Please go back and re-read his article.
Sincerely,
Gary Brown


"BCOz" wrote:

I have already setup to calculate the total for the year, but I only want for
month by month. Is there not a way to say if a:a = jan and c:c = gas then
total column g:g and ignore all other months.

"BCOz" wrote:

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="gas oline"),SUM(Transactions!G:G),0)