SUMIF function with multiple criteria

[anna57]

Hello,

I am trying to get a spreadsheet to give me a column total if the date in another column is in a certain range and if the value in another column reads "DBT training". I have come up with the formula below but apparently it contains an error, is anyone of aware of how I might be able to remedy the problem?

=SUMIF('Main Database'!K$4:K$1700,">"&'Main Database'!$C$1,'Main Database'!S$4:S$1700)-SUMIF('Main Database'!K$4:K$1700,">"&'Main Database'!$G$1,'Main Database'!S4:S$1700)-SUMIF('Main Database'!J4:J1700="DBT training",'Main Database'!S4:S$1700)

Thanks!

Anna

[DonkeyOte]

Without using a helper colum on Main Database sheet you could use SUMRPODUCT.

Based on my interpretation of your prior post formula perhaps

Please Login or Register  to view this content.

Note: in the above I am setting test = DBT (per narrative) rather than <> as implied in your earlier formula

[NBVC]

Try:


=Sumproduct(--('Main Database'!K$4:K$1700>'Main Database'!$C$1),--('Main Database'!K$4:K$1700<='Main Database'!$G$1),--('Main Database'!J4:J1700="DBT training"),'Main Database'!S4:S$1700)