Hi
I have a problem with a formula (SUM.IF) (Please note long formula
There are som dirrent criterias
I have uploadad the file here:
Would be very very happy to get this solved
Have a nice weekend,
Hi
I have a problem with a formula (SUM.IF) (Please note long formula
There are som dirrent criterias
I have uploadad the file here:
Would be very very happy to get this solved
Have a nice weekend,
Last edited by JBeaucaire; 02-20-2016 at 02:31 PM.
I have removed the link to another site for the down load. Please upload your file here in the thread.
EDIT post #1, then GO ADVANCED and use the paperclip icon.
===========
I can tell you now that SUMIF() only allows a single criteria.
But SUMIFS() allows multiple criteria, read the help files in Excel on that function.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi
Thanks for the reply..
I know I can upload here, but it's not working. (Have tryied on 2 diffent machine)
A blank box just shows up.
See screendump here: http://i65.tinypic.com/hvt3di.jpg
Kind regards
My internet security software blocks that link.
McAfee WebAdvisor
Warning: Trouble ahead
Whoa!
Are you sure you want to go there?
http://i65.tinypic.com/hvt3di.jpg may be risky to visit.
Why are you seeing this?
When we visited this site, we found it exhibited one or more risky behaviors.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Perhaps turn on the Compatibility View in the Internet Explorer Compatibility View settings.
http://screencast.com/t/LfZj4NTuv
http://screencast.com/t/uBFqZeHWE
Thanks, but it did't help
Just a blank box
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks