| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sumif depending on 2 cells matching
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) |
|
#2
|
|||
|
|||
|
"Anthony" wrote in message
... 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) Why are you using SUMif? Just use IF. =IF('Cattle Mvts'!E29='Cattle Budget'!D7,'Feedlot Assumptions'!B5*'Cattle Mvts'!C29,0) |
|
#3
|
|||
|
|||
|
ah yes thankyou
enough knowledge to be dangerous sometimes leads us to over complicate matters "Gordon" wrote: "Anthony" wrote in message ... 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) Why are you using SUMif? Just use IF. =IF('Cattle Mvts'!E29='Cattle Budget'!D7,'Feedlot Assumptions'!B5*'Cattle Mvts'!C29,0) |
|
#4
|
|||
|
|||
|
"Anthony" wrote in message
... ah yes thankyou enough knowledge to be dangerous sometimes leads us to over complicate matters You're welcome. We've all been there! <bg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
| how do i use the sumif function in non cons cells | Excel Worksheet Functions | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
| How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
Linear Mode
