This will work best if you remove the summary block and place it in a separate table. Then you can use SUMIF to designate Column A of the entries table as the search range, and Column D of the entries table as the sum range, without having to worry about where the end of the data range is.
"Since I copied the data from the OP post the US $ was simply text."
Copied from the post, it would be text, as I doubt the webpage carries the formatting information specifying currency.
Unless Singh did the calculations in column E manually, though, I suspect the amounts in column D (and E) are numbers, formatted as currency, though. It's possibly a custom format, though. When I tried a variety of currencies from the list provided in the Inspector, none included a space between the currency symbol and the number.
Pasted into this message (below), then copied from here and pasted back into a copy of the table whence they came, only three were recognized as currency; the rest gave the error message shown in the screen shot.
Pasted values to copy:
Screen shot of result described above:
Note: Column A had been formatted to show Currency. The fact that some of these values had been interpreted as Text was initially masked, as the cells had adopted the alight right setting copied from the pasted table in Discussions. The screen shot shows the appearance after the cell alignment had been set to Automatic.
Seems you got a real dumb pupil in me, since earlier too you had helped me out with calculation of interests. Yup your formula's has finally been accepted and mercifully its working. Inexplicably in the example above my data is being summarised for the first four entries of cash and only
Thanks all the same, you clipboard in the message was helpful and self explainatory
Here's a restatement of what Jerry and Wayne have provided above, using the same formula as it would appear in the case where the summary table is separate from the data table.
One advantage to separating the summary table from the data table is that range references can be specified as the whole column. Here's an example, usint a copy of the Data part of your table, and a separate Summary table, modeled after the summary part of your table.
The formula in B2 of the Summary table is shown below.
=SUMIF(Data :: $A,A2,Data :: D)
"Data" in the formula is the name of the large table. Change to match the name of your data table if necessary.
Enter the formula into B2 of the summary table, then fill down to the 'Cheque' row.
Yup detaching the summary block helped, and is working albeit with a little hickup ie only the first entries of cash, cheque or card are being added, Should figure the correct formula.
Thanks for the inputs.
Now you are on the path to the Numbers way of designing spreadsheets. Keep the different tasks separate. One table for data entry, and another for summarizing.
Gave it a shot, yes separating the two tables ie data and summary worked, and inexplicably since the cells are on currency desired results are being obtained and is adding / working with every working day. I was not getting the ' A2' correct, and cosequent to your post in addition to Wayne and Jerry adding to the discussion problem solved.
Thanks ever so much