HI ALL.

This is my first post, requesting your help, after trying out various
suggestions.

In the following data, column 'A' is month (text) & column 'B' contains
training programme codes, (numeric).

I want to get the total of column 'C' & column 'D' respectively, for
particular values specified for column 'A' & 'B', (As noted in the
first line - ie. for MNTH=Jun-06 & PROG=8012):

A B C D
Jun-06 8012 55 0

MNTH PROG POST ATTE
Apr-06 8011 30 25
May-06 8012 28 27
May-06 7010 29 28
Apr-06 7010 30 28
Jun-06 8012 25 29
Jun-06 8011 30 28


I didn't succeed in getting result for
=SUM(IF((A4:A9=A1)+(B4:B9=B1),C4:C8)
: as was suggested in a popular computer magazine. The result returned
was #VALUE in the first part of the logic, (A4:A9=A1).

I tried the option:
=SUMPRODUCT(--(A3:A9=A1),--(B3:B9=B1),D3:D9)
as suggested in several cases, but the value returned was '0' - as
noted in the first line

I WILL BE THANKFUL FOR ANY GUIDANCE IN THE
MATTER, THAT WILL HELP ME IN BETTER USE OF THE DATA IN MY WORK
AREA.
THANKS.

JITU


--
jitu_tikili
------------------------------------------------------------------------
jitu_tikili's Profile: http://www.excelforum.com/member.php...o&userid=33119
View this thread: http://www.excelforum.com/showthread...hreadid=529327