LinkBack URL
About LinkBacks
This is the formula that I am using =SUMIF($D3:$G3,$R$1,$F3:$G3) I want the answer to be F3 + G3, it's giving me only F3. What am I going wrong? Any suggestions?
SUMIF not giving me the correct answer
This is the formula that I am using =SUMIF($D3:$G3,$R$1,$F3:$G3) I want the answer to be F3 + G3, it's giving me only F3. What am I going wrong? Any suggestions?
your formula should be:
or simply:
Please Login or Register to view this content.
try that and see if the result is to your liking.Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
These didn't work. Thanks for your help. I ended up using this formula and it gave me the answer I was looking for. =IF($D3=$R$1,$F3)+IF($D3=$R$1,$G3) probably not the cleanest formula but I got the results. Thanks.
Shorter version..
=IF($D3=$R$1,SUM($F3,$G3),0)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks