Thread: if a:a (range) equals january and c:c equals gas then add g:g ($)
View Single Post
  #1   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 ($)
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