LinkBack URL
About LinkBacks
I want to get a total from a column where the adjacent cells match the criteria, but i keep getting a Value error.
Could someone help? I've attached an example or the table with the formulas I've been trying at the bottomMappe1.xlsx
Thanks guys!
I want to get a total from a column where the adjacent cells match the criteria, but i keep getting a Value error.
Could someone help? I've attached an example or the table with the formulas I've been trying at the bottomMappe1.xlsx
Thanks guys!
If you use an array formula, you must hit Ctrl+Shift+Enter
If you not want use an array formula:
Please Login or Register to view this content.
Last edited by SDCh; 03-26-2014 at 05:54 AM.
Click (*) if you received helpful response.
Regards,
David
Formula:
Please Login or Register to view this content.
Regards, TMS
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
Doesn't look like it needs to be an Array Formula ... it's a simple SUMIF
Regards, TMS
Hi,
See attached.
Since the names are duplicated you need to create a unique list first as I have done in A40:A45
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks guys, the CTRL+SHIFT+ENTER was the main Problem by the Looks of it.
if i wanted to add a second criteria from another adjacent column, i would have to add an "AND" clause in there right?
You really don't need to use Array Formulae, that is, formulae committed with Ctrl-Shift-Enter. You do, as Richard has said, need a list of names.
In the example provided, a SUMIF works fine. And, if you need extra conditions, you would move up to SUMIFS.
The more Array Formulae you have the bigger the impact on calculation time, especially as the amount of data increases.
See the example workbook attached.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks