I get error while i writing a SUMIFS function [VALUE!]
Hello,
I'm having a problem using a SUMIFS function.
When I write the function to the first table everything works fine.
But when I add the second table to it, it shows to me #VALUE!
This is the function that I wrote as you can see in the picture.
What is wrong with writing this function?
Thank you
Try
Formula:
Please Login or Register to view this content.
The most important part is that your row ranges are uniform through out
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
You will need to have two SUMIF formulae and add them together.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You would need separate SUMIFS for the two sets of data.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument.
Ben Van Johnson
Hello AliGW do you mean something like this
Yes, like that.
it work well now as i want,, Thanks you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks