sumif depending on 2 cells matching

G

Guest

I'm trying to write a formula that says if the date in E29 is the same as the
date in D7 then multiply B5 by C29, otherwise 0. Where am I going wrong.I
know what i want to acheive I just don't know how to get there

=sumif('Cattle Mvts'!E29,match('Cattle Budget'!D7,),'Feedlot
Assumptions'!B5*'Cattle Mvts'!C29)
 
G

Gordon

Anthony said:
I'm trying to write a formula that says if the date in E29 is the same as
the
date in D7 then multiply B5 by C29, otherwise 0. Where am I going wrong.I
know what i want to acheive I just don't know how to get there

=sumif('Cattle Mvts'!E29,match('Cattle Budget'!D7,),'Feedlot
Assumptions'!B5*'Cattle Mvts'!C29)
Click to expand...

Why are you using SUMif? Just use IF.

=IF('Cattle Mvts'!E29='Cattle Budget'!D7,'Feedlot
Assumptions'!B5*'Cattle Mvts'!C29,0)
 
G

Guest

ah yes thankyou

enough knowledge to be dangerous sometimes leads us to over complicate matters
 
G

Gordon

Anthony said:
ah yes thankyou

enough knowledge to be dangerous sometimes leads us to over complicate
matters
Click to expand...

You're welcome. We've all been there! <bg>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

a problem with if invovling a range of cells 1
Problem with an "if" relating to a range 7
Sum product help needed with an extra variable please and thankyou 6
Add Cells in a row depending on Date 2
Sumif with Vlookup 1
Sum cells based on a row variable and seperate column variable 10
Changing named range reference depending on a cell's content 1
How to add data from cells based on different criterias? 2

Top