Dear Dave,
Thanks for reply but problem is every sheet inventory ID starts from 01. so
it is difficult that ID code in daily report may be of Paintings, Textiles or
Jewellery. Thats why i asked tha when ID No. Match then Column "Text" Match
after that the formula detects value from respective sheet.

Hope u will once try to understand my problem.


"Dave Peterson" wrote:

Since there's only 3 sheets, why not just use 3 =sumif()'s.

=sumif(...) + sumif(...) + sumif(...)

Just point to the ranges each of the sheets when you're building that part of
the formula.

For what it's worth, I'd try to keep the data in one worksheet--you could always
add another column that could server as some kind of indicator. It really makes
life a lot easier when the data is consolidated.

Rao Ratan Singh wrote:

Dear Sir/mam,
I have three worksheets containing inventory record of paintings, Jewellery
and Textiles.

All have same column = IDNo. Name of Item Price

I submit daily sales report to my boss which have column in this manner-

A B C D E
ID No. Name of Item Cost Price Sale Price Gain/Loss

I m using this function to track value from Painting
=SUMIF(Pntng_ID,B20,Pntng_Cost) in
column C.

Is there any formula to track value from all three sheets putting
"paintings", "Jewellery" and
"Textiles" in column B and in column C the formula can track value according
to Colum B's
Text.

I hope this plateform will definetly solve my problem soon.

--

Dave Peterson