I am having trouble with my SUMIFS STATEMENT.
It's not adding up correctly??
See attached
I have renamed the data file, so that is not the issue..
Please Help !!! I'm pulling my hair out !!!
I am having trouble with my SUMIFS STATEMENT.
It's not adding up correctly??
See attached
I have renamed the data file, so that is not the issue..
Please Help !!! I'm pulling my hair out !!!
What are you looking for with this part (...$A2:$A3000,"*"&D1...) of your equation? Everything else in your SUMIFS makes sense
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
I don't see why the result is incorrect - you have highlighted the cells to be summed in yellow but shouldn't E29 and E31 be included too, that would make the total correct - did you mean to use 14190 rather than 14290?
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks