if a:a (range) equals january and c:c equals gas then add g:g ($)

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)

You want to sum on multiple criteria. You need an array formula.
Check out Chip Pearson's website. Specifically...
http://www.cpearson.com/excel/array.htm
He gives an example of exactly what you want.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


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

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

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

I assume you are setup like this
A B C
25.00 Gas Jan
So, what you could do in D is type =B1&C1 for the result "GasJan"...copy the
formula down the page. On the other sheet, type "GasJan", or use a formula
as above. Now all you have to do is use a SUMIF formula that "looks for"
GasJan in col. D and sums col. A.
"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="gasoline"),SUM(Transactions!G:G),0)