Thread: if a:a (range) equals january and c:c equals gas then add g:g ($)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BCOz
 
Posts: n/a
Default if a:a (range) equals january and c:c equals gas then add g:g ($)
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)
Reply With QuoteReply With Quote