Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMPRODUCT (Again!)
Another simple one, I'm sure. I have this simple formula: =I28+7
I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
#2
|
|||
|
|||
One way:
=I28 + 7 + 14*(COUNTIF(E28:E500,"TBG")0) If TBG is a partial match, use "*TBG*" instead. In article , "Connie Martin" wrote: Another simple one, I'm sure. I have this simple formula: =I28+7 I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
#3
|
|||
|
|||
how about
=l28+if(countif(e28:e500,"TBG")0,14,7) or l28+7+if(countif(e28:e500,"TBG")0,7,0) -- Don Guillett SalesAid Software "Connie Martin" wrote in message ... Another simple one, I'm sure. I have this simple formula: =I28+7 I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
#4
|
|||
|
|||
The formulas you have given are adding too many days (21 and 14) where TBG is
not in E28:E500. Perhaps I didn't explain myself well enough. I28 is a date and in M28 I want a date that's 7 days later than I28, but if E28 says "TBG" then I want M28 to add 14 days. If E28 says anything else it's to add only 7 days in M28. Connie "Connie Martin" wrote: Another simple one, I'm sure. I have this simple formula: =I28+7 I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
#5
|
|||
|
|||
Hi
try =I28+7+7*(E28="TBG") -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... The formulas you have given are adding too many days (21 and 14) where TBG is not in E28:E500. Perhaps I didn't explain myself well enough. I28 is a date and in M28 I want a date that's 7 days later than I28, but if E28 says "TBG" then I want M28 to add 14 days. If E28 says anything else it's to add only 7 days in M28. Connie "Connie Martin" wrote: Another simple one, I'm sure. I have this simple formula: =I28+7 I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
#6
|
|||
|
|||
Thank you! That did it. So, one doesn't use SUMPRODUCT here! No wonder I
get nowhere with these formulas! Ha! :) Have a nice day, or is it evening in Germany now? It's just noon here in Canada now. Connie "Frank Kabel" wrote: Hi try =I28+7+7*(E28="TBG") -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... The formulas you have given are adding too many days (21 and 14) where TBG is not in E28:E500. Perhaps I didn't explain myself well enough. I28 is a date and in M28 I want a date that's 7 days later than I28, but if E28 says "TBG" then I want M28 to add 14 days. If E28 says anything else it's to add only 7 days in M28. Connie "Connie Martin" wrote: Another simple one, I'm sure. I have this simple formula: =I28+7 I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
#7
|
|||
|
|||
Hi Connie
good it works for you :-) Frank P.S.: it's around 6pm here in Germany on a quite nice winter day. Time to buy some presents... -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... Thank you! That did it. So, one doesn't use SUMPRODUCT here! No wonder I get nowhere with these formulas! Ha! :) Have a nice day, or is it evening in Germany now? It's just noon here in Canada now. Connie "Frank Kabel" wrote: Hi try =I28+7+7*(E28="TBG") -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... The formulas you have given are adding too many days (21 and 14) where TBG is not in E28:E500. Perhaps I didn't explain myself well enough. I28 is a date and in M28 I want a date that's 7 days later than I28, but if E28 says "TBG" then I want M28 to add 14 days. If E28 says anything else it's to add only 7 days in M28. Connie "Connie Martin" wrote: Another simple one, I'm sure. I have this simple formula: =I28+7 I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
#8
|
|||
|
|||
Have a safe and happy holiday season. Thank you for all your help this past
year. Connie Martin Canada "Frank Kabel" wrote: Hi Connie good it works for you :-) Frank P.S.: it's around 6pm here in Germany on a quite nice winter day. Time to buy some presents... -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... Thank you! That did it. So, one doesn't use SUMPRODUCT here! No wonder I get nowhere with these formulas! Ha! :) Have a nice day, or is it evening in Germany now? It's just noon here in Canada now. Connie "Frank Kabel" wrote: Hi try =I28+7+7*(E28="TBG") -- Regards Frank Kabel Frankfurt, Germany "Connie Martin" schrieb im Newsbeitrag ... The formulas you have given are adding too many days (21 and 14) where TBG is not in E28:E500. Perhaps I didn't explain myself well enough. I28 is a date and in M28 I want a date that's 7 days later than I28, but if E28 says "TBG" then I want M28 to add 14 days. If E28 says anything else it's to add only 7 days in M28. Connie "Connie Martin" wrote: Another simple one, I'm sure. I have this simple formula: =I28+7 I want to add to this that it's to add 14 if "TBG" is found in E28:E500, otherwise add only 7. Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumif not Sumproduct | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions | |||
SUMPRODUCT using offset from ROW if X marks the spot | Excel Worksheet Functions |