Conditional sum if

[nagesh.tvsr]

Hi,

I need a sumif formula with conditions.

Pl. find attached an excel file with details.

Pl. help.

Regards,
Nagesh.

[samba_ravi]

How you arrived 19 in J7

[Richard Buttrey]

Hi,

Without a helper column or array formula you'll need a SUMPRODUCT function. i.e.

Please Login or Register  to view this content.

[nagesh.tvsr]

Hi Richard,

Thanks for immediate response. The answer should be 14 (sorry indicated in the file as 19) (only cell: E10) (Where month, year and job number matches)

Hi Siva,

There was a mistake. The answer should be 14 only.

Pl. help.

Thanks,
Nagesh.

[JohnTopley]

Try

=SUMPRODUCT((LEFT($D$5:$D$17,8)=$I$7)*($E$5:$E$17)*(MONTH($C$5:$C$17)=$H$6)*(YEAR($C$5:$C$17)=YEAR(TODAY())))

[nagesh.tvsr]

Perfect.

Thanks a ton John.

[JohnTopley]

Thank you for the feedback and rep.