How to get sum of different criterias in one cell

[devawad]

HOW TO GET SUM OF DIFFERENT CRITERIAS IN ONE CELL,

If, I put invice or source code or material or sales area in cell B14 total should come in D14

I attached sample sheet plz help

[oeldere]

2 solutions,

Pivot table

or

sumif

See the attachment

[jason.b75]

Try

=SUMPRODUCT(($A$2:$D$9=B14)*$E$2:$E$9)

[BarryTSL]

I have added an extra cell so you need to choose the title first, the next cell is also a drop down box with the options set from the first cell. Hope this works for you.

[devawad]

thanks dear thank you very much

---------- Post added at 02:21 PM ---------- Previous post was at 02:21 PM ----------

solved thanks.