Hi all,
I am strugling with a caculation of mine.
Basically I want to combine two SUM IF functions into one. I.e.
SUMIF(range C:C,criteria J2,sum range D:D) & SUMIF(range BB, criteria H12, sum range D:D)
Does anybody know if this is possible.
Hi all,
I am strugling with a caculation of mine.
Basically I want to combine two SUM IF functions into one. I.e.
SUMIF(range C:C,criteria J2,sum range D:D) & SUMIF(range BB, criteria H12, sum range D:D)
Does anybody know if this is possible.
assuming you don't want double counts in column d
try sumproduct()
=sumproduct(--(c1:c6400=$j$2),--(B1:b6400=$H$12),d1:d6400)
the --() changes the logical true or false to 1 or 0
in sumproduct you can't specify the entire column such as C:C it has to be a
specific range,
in sumproduct all of the arrays need to be the same size
"moglione1" wrote:
>
> Hi all,
>
> I am strugling with a caculation of mine.
>
> Basically I want to combine two SUM IF functions into one. I.e.
>
> SUMIF(range C:C,criteria J2,sum range D:D) & SUMIF(range BB, criteria
> H12, sum range D:D)
>
> Does anybody know if this is possible.
>
>
> --
> moglione1
> ------------------------------------------------------------------------
> moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
> View this thread: http://www.excelforum.com/showthread...hreadid=562422
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks