I would like to sum the values of cells in a column where corresponding cells in another column equal any one of five or so text values.
Any help is greatly appreciated.
Thank you.
_t
I would like to sum the values of cells in a column where corresponding cells in another column equal any one of five or so text values.
Any help is greatly appreciated.
Thank you.
_t
Have you tried a LOOKUP function combined with a SUM function?
When I say semicolon, u say comma!
Hi,
=SUMPRODUCT(SUMIF(range_to_sum,range_which_holds_5_criteria,range_in_which_to_search_for_criteria))
e.g.
=SUMPRODUCT(SUMIF($E$1:$E$8,$A$1:$A$5,$D$1:$D$8))
Regards
Thanks XOR LX.
That did the trick except the ranges seemed to be swapped.
=SUMPRODUCT(SUMIF(range_in_which_to_search_for_criteria,range_which_holds_5_criteria,range_to_sum))
Seemed to function as desired.
Thanks again!
_t
Ah, um...yeah! Just testing you!
(I never liked the order of syntax for this formula anyway!)
Well spotted!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks