Sumif problem

  • Thread starter Thread starter potain
  • Start date Start date
P

potain

Hello

I have a simple bank reconcilialtion spreadsheet which uses a sumi
function to total the different debits and and I would like to know i
I can total these using the date column. Here are the fields:
date (A) transaction details (B) category (C) debit (D) credit (E
balance(F)

The date is a date field formatted as ddd - dd - mmm - yy (Fri - 02
Jan - 04)

Also is there a formula that one can use to reflect the curren
balance?

Please see the attached file.

thank yo

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45401
 
Hi
change the formula in I4
=SUMIF(C3:C10,$C$3,E3:E10)
to
=SUMPRODUCT(($C$3:$C$1000=C$3)*(ISNUMBER(FIND($H4,$A$3:$A$1000))),$E$3:
$E$1000)
copy this down and to the left

You may consider using real dates in column A and H
 
Hi Frank

Thanks for the reply. I did as you suggested and pasted your suggeste
formula into the cell (I4) but the result of $0.00.

Jean
(potain
 
Hi Jean
change the name of the months in H4:H12 as follows:
'jan' -> 'Jan'
'feb' -> 'Feb'
....
to get a match or change the formula to
=SUMPRODUCT(($C$3:$C$1000=C$3)*(ISNUMBER(FIND(LOWER($H4),LOWER($A$3:$A$
1000)))),$E$3:$E$1000)
 
Back
Top